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.

“Memory is like an orgasm. It's a lot better if you don't have to fake it.” - Seymour Cray