Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> simple query

simple query

From: <esukkar_at_gmail.com>
Date: 23 May 2005 22:11:14 -0700
Message-ID: <1116911474.062345.160360@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US