Re: fast select of first row on Oracle table...

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Thu, 4 Mar 1999 13:42:39 -0000
Message-ID: <920555140.8526.0.nnrp-11.c2de6f3d@news.demon.co.uk>

Can't you simply

select * from <table> where rownum = 1

or am I missing something ?

tim.mcconechy_at_runtime.dk wrote in message <7blnbl$1m0$1_at_nnrp1.dejanews.com>...
>How can I select the first row in a table...
>I thought of doing.
>select * from dbstruct where recno=(select min(recno) from dbstruct)
>but this invlove table scanning which shouln't be necessary...
>
>I just want the first row...Fast!
>
>Please help...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 07:42:39 CST