Re: about SQL Select statement

Thanks for your response. The problem is: I am using a JDBC Thin driver and trying to get the information about some table - I don't know the field name and type - just know the name of the table. I cannot get MetaData through the connection. Do you know any way to get these information?

Thanks

Peter

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<mqI87.415239$p33.8425115_at_news1.sttls1.wa.home.com>...
> If you know what row you want specify it. That is what makes the particular
> row that you want unique?
> You can do select ... from ... where rownum=1 ... to get the first row.
> To get any particular row what is special about it?
> Jim
> "SQL Dummy" <hza63_at_hotmail.com> wrote in message
> news:fd0a0e63.0107281537.51091196_at_posting.google.com...
> > I have a question to use SQL select statement:
> > How can I just get one row from a table? (for example, first row or
> > any row?)
> >
> > Thanks
> >
> > SQL Dummy
Received on Sun Jul 29 2001 - 20:18:27 CDT