Re: Simple Query of multiple record

Want you want is (something like)

SELECT name
FROM emp
WHERE sal > ( SELECT sal

		FROM    emp
		WHERE rownum < 4
		ORDER BY SAL DESC)

Joseph Jao <jjao_at_idt.net> wrote in article <33273FF8.F08_at_idt.net>...
> Hi, I tried to make a simple SQL command query to get the names of 3 top
> paid persons. "Select name, sal from emp where rownum<4 order by sal
> desc;" doesn't work. "Select name, sal from emp order by sal desc;"
> works but it'll bring everything. Can anyone help me?
>
> jjao_at_idt.net
>
  Received on Thu Mar 13 1997 - 00:00:00 CST