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

Home -> Community -> Usenet -> c.d.o.tools -> Re: first row with sql?

Re: first row with sql?

From: Ole Christian <olecl_at_stud.idb.hist.no>
Date: Mon, 02 Apr 2001 11:39:54 +0200
Message-ID: <3AC848EA.7D81549E@stud.idb.hist.no> 






gg200492 wrote:



> With MSaccess  there is a 'Group by' function FIRST which select only

> the first row of each group like SUM,AVG etc...

>

> how to do that with Oracle SQL?

>

> thanks for help




Try: where rownum=1



Quite the deja-vu this question of yours...



Ole C.
Received on Mon Apr 02 2001 - 04:39:54 CDT












Original text of this message













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