Re: Q: SQL -Only the first of every row ?

Hi Ralf,

Ralf Bender schrieb:
> I got a little problem to solve. There is a table like this:
> objectnr, names, dates
> 123,data1,2004
> 123,data1,2003
> 234,data2,2003
> 456,data3,2004
> 456,data4,2004
>
> Now i want to select all rows which have 2004 in field dates, BUT i only
> want to see every objectnr once and all columns.
>
> The result should look like this:
> 123,data1,2004
> 456,data3,2004

select objectnr, names, dates

   from $your_table
  where dates=2004
  group by objectnr

regards
Frank Received on Wed Aug 04 2004 - 07:13:43 CDT