hi all,

can any one help me to write query  for subtracting 7 days from date,

in that column all date are same in every row , upto 53 times.

i want to...