OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Top 20

Sun, 24 February 2002 19:20

Gopal Raw
Messages: 19
Registered: January 2002

Junior Member

How can i select top 20 rows from a table in oracle 8.
ex.. I want to select top 20 salary from a tab.

Sun, 24 February 2002 19:30

Tariq Zia lakho
Messages: 8
Registered: February 2002

Junior Member

SELECT SAL
FROM EMP
WHERE ROWNUM < 21;

Mon, 25 February 2002 04:52

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

SELECT a.empno,a.sal
FROM emp a
WHERE 20=
(SELECT
COUNT(DISTINCT(sal))
FROM emp b
WHERE a.sal<=b.sal)

Previous Topic:	Urgent! IDEPTREE and DEPTREE
Next Topic:	Setting the alignment property for a text item

Goto Forum:

]

Current Time: Thu Apr 25 09:02:32 CDT 2024