Posted by tamashee on 04/14/06 03:27

Hi,
I have the following set and would like to select all rows that have
min value of column 4 for a given column 1 and 2 group, irrespective of
column 3, as below:

C1 C2 C3 C4
---------------------
A B x 5
A B y 10
A BB XX 55
A BB YY 11
AA CC z 1
AA CC zz 11

Need
---
A B x 5
A BB YY 11
AA CC z 1

using sql server 2000 (which does not provide rank or partition by)
Thanks in advance,
Tamas

• Next in forum: Re: selecting a set for min value
• Prev in forum: Re: Left Joins and record insert problems
• Thread view: selecting a set for min value

[Reply to this message]