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

>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 Received on Tue May 28 1996 - 00:00:00 CEST