Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete all but top 100 rows
Message
From
15/05/2014 10:27:34
Nicholas Mason
London, United Kingdom
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Delete all but top 100 rows
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01600029
Message ID:
01600029
Views:
75
HI

Whats the easiest way to delete all but the top 100 rows from a table.

I'm testing somehting but I don't want to shove tens of thousands of records through it yet.

Thanks

Nick
Next
Reply
Map
View

Click here to load this message in the networking platform