Re: A newbie question about select record with distinct colum?

From: Falko Rotter <fantomas99_at_gmx.de>
Date: Mon, 20 Aug 2001 10:42:10 +0200
Message-ID: <9lqieu$ir3$1@newsread2.nexgo.de>

Hi,

> c1 c2 c3 c4 c5
> A1-X21 000123456 100 EA part_A
> A1-X22 000123456 100 EA part_A
> B1-Z12 000123456 2 EA part_A
> C1-X13 000123456 10 EA part_A
> B1-Z11 000654321 20 EA part_B
>
> and I want my select result as
> A1-X21 000123456 100 EA part_A
> B1-Z11 000654321 20 EA part_B
>

please explain me how and why is this your result! - do you want to group only by field c2 ? - how should aggregate the other fields in the group ?

Regards,
Falko Rotter

Software Developer -

Rotter & Kalweit Softwaredesign GbR
Friemarer Straße 38

99867 Gotha
GERMANY mail: news_at_falko-rotter.de Received on Mon Aug 20 2001 - 03:42:10 CDT