i want to get dat from a table based on -
field_1,field_2,field_3,field_4 will be system dates data and field_5,field_6,field_7,field_8 will be previous days data, and date will be system date
. Pls check the below image.
how can i write the query to get this result?i am using ms sql.
What you want OutPut?
Please check this below.
can any one help me to solve this