Re: simple SQL query problem

From: Mats Larsson <matlar_at_rsv.svskt.se>
Date: 1995/09/21
Message-ID: <1995Sep21.161808.22824_at_rsv.svskt.se>#1/1


In article <DF78Bq.99I_at_news.cern.ch>, Maria.SKIADELLI_at_cern.ch (Maria SKIADELLI) says:
>
>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
>

add this to your where condition:
 rownum < 1

Mats Larsson          |  Tel:   +46 8 7647921
RSV DataService       |  Fax:   +46 8 983146
171 94 Solna, Sweden  |  Email: matlar_at_rsv.svskt.se
Received on Thu Sep 21 1995 - 00:00:00 CEST

Original text of this message