Re: simple SQL query problem

In article <DF78Bq.99I_at_news.cern.ch>,

   Maria.SKIADELLI_at_cern.ch (Maria SKIADELLI) wrote:
>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 limiting the result with ROWNUM?

(ie. SELECT * FROM TBL_A WHERE ROWNUM < 2 )

Hope this helps. Received on Wed Sep 20 1995 - 00:00:00 CEST