Home » SQL & PL/SQL » SQL & PL/SQL » qUERRY HELP
qUERRY HELP [message #254130] Wed, 25 July 2007 18:02 Go to next message
Nokia
Messages: 15
Registered: July 2007
Junior Member
How i can select 3 max vlause from a single column;
SNO
----------
1
2
3
4
77
55
i want ouput like

77
55
4

Thanks
Re: qUERRY HELP [message #254132 is a reply to message #254130] Wed, 25 July 2007 18:20 Go to previous messageGo to next message
BlackSwan
Messages: 25579
Registered: January 2009
Location: SoCal
Senior Member
search this forum for "TOP N".
Re: qUERRY HELP [message #254161 is a reply to message #254130] Thu, 26 July 2007 00:55 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: HOW TO GET FIRST DATE OF ENTERED DATE
Next Topic: Sytem Triggers at Database level
Goto Forum:
  


Current Time: Wed Aug 23 08:59:20 CDT 2017

Total time taken to generate the page: 0.09205 seconds