SQL "select" query

Question

I'm sure this is super-easy, I just haven't drunk enough coffee today....

So, I have a single table with a few columns, like:

NAME1 val1 val2 val2
NAME2 val1 val2 val3

There are only about 20 distinct names the first column holds, the values are real but duplicates happen sometimes. I have to find the best ranking row for each distinct NAME. The ranking is done by sorting first by val1 then val2 then val3

Edit: So here is an example:

Ben    2.1 1.0 0.6
Ben    0.1 1.0 0.6
Ben    2.1 0.9 0.1 
Alice  2.1 0.9 0.1 
Alice  2.0 0.9 0.1

The answer should be:

Ben    2.1 1.0 0.6
Alice  2.1 0.9 0.1

Manish · Accepted Answer · 2011-11-17 11:39:23Z

1

select [name],max(val1) as val1,max(val2) as val2,max(val3)as val3 from sql_select group by [name] order by val1 desc, val2 desc, val3 desc;

edited Nov 17, 2011 at 11:39

answered Nov 17, 2011 at 11:18

Manish

5171 gold badge3 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BuZz · Accepted Answer · 2011-11-16 11:54:08Z

0

select * from table order by val1, val2, val3

You didn't document much, can't be more precise until you give more

answered Nov 16, 2011 at 11:54

BuZz

17.6k35 gold badges94 silver badges148 bronze badges

1 Comment

BuZz Over a year ago

look at 'desc' to reverse the sort

Collectives™ on Stack Overflow

SQL "select" query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related