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

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).

Thanks
Stefan
Re: top 50 [message #252827 is a reply to message #252826] Fri, 20 July 2007 03:09 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just by searching for "top n" in any forum or google.
Closed.
./fa/448/0/
Regards
Michel
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: Sun Dec 04 20:38:08 CST 2016

Total time taken to generate the page: 0.04115 seconds