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
>

Something like this should work. It doesn't work so well with ORDER BY or GROUP BY clauses, if you're selecting more than 1 row.

select 	*
from	blahblah
where	rownum = 1
and	.
	.
	.