Re: Tricky SQL Problem: Top "n" of queried records

Brenda Muller wrote:

> In Sybase (and Sybase alone), you can "set rowcount 3" at the beginning of your
> transaction, which will restrict the server to returning only 3 rows. There is
> nothing analogous to this in Oracle.
>
> Brenda Muller
>

Yes, the following should be equiv. in Oracle:

SELECT deptno, sum(salary) FROM emp
GROUP BY deptno
...order by something relevant....
WHERE ROWNUM < 4;

But you must sort the resultset so the rows you are interested in are placed first.

Best regards

Johan Thorselius Received on Sat Mar 21 1998 - 00:00:00 CST