RE: help with query :)

This_is_strange, because I have tried the following two queries on the Scott demo table Emp and it worked. Let's see what Yohans says from his experience.

Regards,

Aleem

Following is the result from both queries.

SELECT EmpNo FROM Emp ORDER BY EmpNo DESC EMPNO

      7934
      7902
      7900
      7876
      7844
      7839
      7788
      7782
      7698
      7654
      7566
      7521 In the second query
      7499 In the second query
      7369 In the second query

SELECT EmpNo FROM Emp WHERE ROWNUM <= 3 ORDERY BY EmpNo DESC

EMPNO

      7521
      7499
      7369


	-----Original Message-----
	From:	Serge Kosourikhin [mailto:kosour_at_braz.ru]
	Sent:	02 June, 2000 2:22 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: help with query :)

	It _shuldn't_ work, because ROWNUM works before order by, not after.

	Serge Kosourikhin
	Oracle DBA
	JSC Bratsk Aluminium Plant
	----- Original Message -----
	To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	Sent: Friday, June 02, 2000 4:44 PM