How to get the first four rows???
From: Ramesh Garapaty <gramesh_at_ix.netcom.com>
Date: 1996/05/17
Message-ID: <4ngu2j$id4_at_dfw-ixnews9.ix.netcom.com>#1/1
Date: 1996/05/17
Message-ID: <4ngu2j$id4_at_dfw-ixnews9.ix.netcom.com>#1/1
Hi!
I have a SQL as follows:
SELECT x_date
FROM y_table
ORDER BY x_date desc
However I want the first four rows only. If I say WHERE rownum < 5 it returns the rows even before sorting by descending order. All I want to see is the latest four dates from the database. Is there a SQL with which we can do this???
Thanks
Ramesh Received on Fri May 17 1996 - 00:00:00 CEST