HI, I have a table with the below structure.. now i want
to delete all those id's where the stock_codes are similar
within last two months from the min(date).. for instance the below id shall
be deleted as it has the same stock_code within 2 months..
ID Date stock_id
4942129 2007-12-26 00:00:00.000 ANIKOCM205117830
4942129 2008-01-27 00:00:00.000 ANIKOCM205117830
can anybody please give me that sql code please ?