Home » SQL & PL/SQL » SQL & PL/SQL » top 50
top 50 [message #252826] Fri, 20 July 2007 03:07 Go to next message
Messages: 112
Registered: July 2006
Senior Member

I have a table where I have a parameter P1. How can I create a new table with the top 50 records (the 50 records with the highest parameter P1).

Re: top 50 [message #252827 is a reply to message #252826] Fri, 20 July 2007 03:09 Go to previous message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just by searching for "top n" in any forum or google.
Previous Topic: How to do merge report in SQL
Next Topic: can we revert value of boolean column in single statement
Goto Forum:

Current Time: Thu Aug 17 08:49:07 CDT 2017

Total time taken to generate the page: 0.08073 seconds