Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> simple query
Hi all,
I need to run a query, and get a single row for a result. for example, if the query was:
select site from site_table
and the result would be:
washington
washington
washington
washington dc
washington
washington
wash. dc
wasingtonDc
here there are 8 results - or rows. However, if i used select distinct, i would still get 4 rows, as there are 4 distinct entries. However, I only want 1 result. I dont care which one it returns, just as long it only ever returns one result.
is there a way to have something like
select (only one) site from site_table.
Thanks for any help in advance.
Cedop Received on Tue May 24 2005 - 00:11:14 CDT
![]() |
![]() |