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 Sat Jul 28 2001 - 19:04:34 CDT
