XPost: comp.databases.oracle.misc, microsoft.public.sqlserver.programming,   
   comp.databases.ibm-db2   
   From: george.dainis@bluecorner.com   
      
   How do I code a SQL SELECT statement so that always only this record is   
   retrieved   
   which matches a certain criteria AND has the lowest ID (= value in key field   
   aaa)?   
      
   It must me something like   
      
   SELECT * FROM .... WHERE somefield='somevalue' AND aaa=lowestkey(column(aaa))   
      
   As a result either zero or at most 1 record should be passed back.   
      
   George   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)