Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: SQL -Only the first of every row ?
Frank Dietrich wrote:
> Hi Ralf, > > Ralf Bender schrieb: >
> > > select objectnr, names, dates > from $your_table > where dates=2004 > group by objectnr > > regards > Frank
Look up information on the proper use of GROUP BY.
You have no aggregation taking place.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Aug 04 2004 - 22:22:06 CDT
![]() |
![]() |