Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving first row of a query in Oracle SQL

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US