Re: Top 20 records in a table ??
From: Lindsay Walker <lindsay.walker_at_portfolio.co.uk>
Date: Mon, 10 Jan 2000 10:32:06 -0000
Message-ID: <947500462.2120.0.nnrp-14.c1c33102_at_news.demon.co.uk>
Date: Mon, 10 Jan 2000 10:32:06 -0000
Message-ID: <947500462.2120.0.nnrp-14.c1c33102_at_news.demon.co.uk>
SELECT pay
FROM emp
WHERE rownum < 21
ORDER BY pay DESC
> How to select the highest 20 records from a table via sql*plus ??
> For example,
> emp table
> ----------------
> id number(5),
> name varchar2(20),
> pay number(8)
>
> how to select the highest 20 pay from emp ??
Received on Mon Jan 10 2000 - 11:32:06 CET