Re: SQL Query

From: Joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: Fri, 28 Jan 2000 10:24:07 -0000
Message-ID: <86qk3u$6oq$1@mailgate.ikea.com>

How would you know which is the first record in the database?

You can allways do select * from table where rownum <2

this will return the first hit but there is really no way of telling if this the first record. It seems like a very unrealiable way of doing things anyway. Save you records with a time stamp instead.

Regards
/Joachim
Kinna Patel wrote in message <389022f6.2081212_at_news.demon.co.uk>...
>How can I write an SQL query which will return the first record in a
>recordset. Under SQL Server 7 you can use the keyword TOP but this
>does not work under Oracle.
>
>Thanks in advance
Received on Fri Jan 28 2000 - 04:24:07 CST