| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> SQL
How do i get (using sql) the top x salary using the emp table?????
eg emp1 salary 10
emp2 salary 5
emp3 salary 6
emp4 salary 8
emp5 salary 3
emp6 salary 2
to get the top 3 earners result will be
emp1 salary 10
emp4 salary 8
emp3 salary 6
How can i get this result using sql ????????
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jul 21 1999 - 07:46:14 CDT
 |
 |