Community discussion forum

How to delete set of records

• • Reply

  10 months ago

  by dotnetguts

  DotNetGuts (DNG)

  INDIA, India

  Joined 3 years ago
  How can i delete *set *of **records**. Example: Set of Rows More than 5 for Particular Group. I need to delete all Rows Greater than 5, starting deleting oldest and keep the latest rows. * Please Help me with this
  Post was edited on 07/01/2009 20:21:27 Report abuse
• • Reply

  10 months ago

  by srajasoft

  srajasoft

  , India

  Joined 1 year ago
  Try with Order clause ex: delete from table1 where column1>5 order by column Desc
  Report abuse