Re: How to get the first four rows???

In <1996May28.093557.25727_at_ucl.ac.uk> Wilfred Ng <siuhungn> writes:
>
>>Muhammad A. Malik's solution worked when I tried this out
>>As for the two or more dates having equal dates, since my orderdate
>>was from sysdate which had time in it as well.
>>It was ok.
>>
>>
>>Andal Nalina
>>Consultant
>>Deloitte & Touche Consulting Group
>>DRT Systems International L.P,
>
>Of course it works in this circumstance. But I just saying that in
 general
>there is no GOOD way to retrieve first n tuples in simple SQL. Your
 case is
>just a special case in the sense that EVERY tuple is UNIQUE. So there
 is no
>contradication to what I meant.
>
>Thanks.
>
>Cheers,
>Wilfred.
>UCL, London
>
>

Wilfred, how about using ROWNUM?

select * from T where rownum < &N; Received on Tue Jun 04 1996 - 00:00:00 CEST