OraFAQ Forum: Server Administration » Help - Select statement to get top 5 rank

Home » RDBMS Server » Server Administration » Help - Select statement to get top 5 rank

Thu, 16 November 2000 21:04

Rudi Triatmono
Messages: 1
Registered: November 2000

Junior Member

Can somebody help me...

How can we get top 5 rank from one table with select statement...??

I really appreciate your help

Regards

Rudi Triatmono

Fri, 17 November 2000 02:25

devendra vaidya
Messages: 2
Registered: November 2000

Junior Member

select a.salary,a.emp from emp a
where 3 > (select count(*) from emp where a.salary < salary)

Wed, 13 June 2001 10:12

Manish Sohaney
Messages: 2
Registered: June 2001

Junior Member

SELECT * FROM EMP WHERE ROWNUM < 6 ORDER BY SALARY;

Wed, 13 June 2001 10:19

Manish Sohaney
Messages: 2
Registered: June 2001

Junior Member

SELECT * FROM EMP WHERE ROWNUM < 6 ORDER BY SALARY;

Previous Topic:	Oracle 8.1.7.0 under Sun Solaris 2.6
Next Topic:	How to store a Lotus Notes-file?

Goto Forum:

]

Current Time: Thu Jul 04 21:33:25 CDT 2024