Information générale
Titre:
A very simple but complicated SQL statement.
I am using ORACLE 7.3 .
I have one table "employee" with a column "sal" .
I have inserted the data into the sal in random order.
Now I want to retrive the rows from that table who draw the maximum salary. (sal).
That is first 5 records after the list is selected by using "order by desc " clause.
I want to use single SQL statement.
some thing like this algorithm.
select first 5 records from ("select sal from employee order by sal desc " )
I tried to use rownum, count() etc. but in fail.
I dont want to use Foxpro .
--Satya
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement