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: 25038
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: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: ORA-00936 when using distinct
Next Topic: ORA-00604: error occurred at recursive SQL level 1
Goto Forum:
  


Current Time: Mon Dec 05 15:10:36 CST 2016

Total time taken to generate the page: 0.07918 seconds