How to delete set of records

sql , server India
  • 8 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
  • 8 years ago
    Try with Order clause ex: delete from table1 where column1>5 order by column Desc

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.” - Rich Cook