Re: simple SQL query problem

 In article <DF78Bq.99I_at_news.cern.ch>, Maria.SKIADELLI_at_cern.ch (Maria SKIADELLI) writes:
> Hello there,
> is there anybody that knows how can I select using an SQL statement
> only one member-record of a set that matches a certrain condition,
> (no matter which one)?
>
> Thanks
> Maria Skiadelli
> CERN AT/IC
> mskiadel_at_cernvm.cern.ch
>

Have you tried to use the pseudo column 'rownum' to limit the number of rows return by your query?

ie:

select * from table
where (.....)
AND rownum <= 1;

Pierre.

-- 
------------------------------------------------------------------------------
Pierre Hollard                                 
Oracle Database Administrator                  Phone: (404) 827-0656
Turner Broadcasting System, Inc.              E-Mail: phollard_at_dev1.turner.com
------------------------------------------------------------------------------