Posted by Tom Moreau on 04/14/06 03:42

Please don't multi-post. I have already answered this in the Microsoft
newsgroups.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
<tamashee@yahoo.com> wrote in message
news:1144974479.938931.193480@z34g2000cwc.googlegroups.com...
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: SQL Server 2005 vs Oracle
• Prev in forum: selecting a set for min value
• Thread view: Re: selecting a set for min value

[Reply to this message]