By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

selecting a set for min value

P: n/a
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

Apr 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
..
<ta******@yahoo.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.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

Apr 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.