Re: simple SQL question ?

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/04/08
Message-ID: <9gyH4.2843$042.15751@typhoon.southeast.rr.com>#1/1

Type:
select * from sometable where rownum=1;

If table has at least one row you will see it.

Paul

"Eric Chow" <eric138_at_yahoo.com> wrote in message news:8cm3to$3o5$1_at_nnrp1.deja.com...
> Hi,
>
>
> "select * from sometable" will get all the contents of the table, right?
>
> But, if I want to show all the fields but only display one record, how ?
> The condition is that, I don't know the structure of that table.
>
> So, I have to use "select * from sometable". So, can I add some
> condition in it to only display one record with all the fields without
> knowing the table structure and the contents of the table ?
>
> Best regards,
> Eric
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Apr 08 2000 - 00:00:00 CDT