Re: Retrieving first row of a query in Oracle SQL

From: <vitalisman_at_gmail.com>
Date: Fri, 31 Aug 2007 06:19:03 -0700
Message-ID: <1188566343.607850.310870@w3g2000hsg.googlegroups.com>

Maybe something like that ?

select * from t where to_char(dat)||cnt = (

   SELECT to_char(dat)||min(cnt)
   FROM T

      WHERE dat = (
         SELECT MIN(dat)
         FROM T
      )

    group by dat
) and rownum=1 Received on Fri Aug 31 2007 - 08:19:03 CDT