Re: simple SQL question ?

From: Haggai <haggais_at_surfree.net.il>
Date: 2000/04/08
Message-ID: <38ef3be4@news.barak.net.il>#1/1

select * from sometable where rownum = 1

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