Re: simple SQL query problem

Maria SKIADELLI (Maria.SKIADELLI_at_cern.ch) 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)?

if i understand correctly, something like:

select ....
from the_table a
where

      a.rowid = ( select max(b.rowid)
                  from   the_table b
                  where  b.aaaa = a.aaaa
                );

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************