Advanced SELECT query

Question

Here's an example of my table:

Skill | SkillLevel

1 | 1

1 | 2

1 | 3

2 | 1

2 | 2

3 | 1

3 | 2

3 | 3

3 | 4

So, I want to write a query which returns me Skill 1 SkillLevel 3, Skill 2 SkillLevel 2 and Skill 3 SkillLevel 4 - Moreover, a select query to select one row of each Skill, but the one with the highest SkillLevel. All in one query, I'm clueless.

Thanks in advance

Edit: The table contains about 200 different Skills.

A simple max and group by will solve this,isn't it ?Please google first. — Jarvan, Aug 01 '13 at 01:03
What a tease, I came expecting a request for an "Advanced SELECT query" and it's this... — Hart CO, Aug 01 '13 at 02:02

score 3 · Answer 1 · edited Jan 31 '14 at 21:51

3

select Skill, max(SkillLevel)
from table_name
group by Skill

Put all of the skills into groups. Then take the max from each group. Put the correct table name where I have "table_name". This returns pairs made of:

a Skill
and the max Skill Level for that skill.

edited Jan 31 '14 at 21:51

Aaron

1,361
1
13
30

answered Aug 01 '13 at 01:07

Will Newton

1,583
13
10

Damn it! I love these simple answers to pimp my score. All answered. – Fandango68 Aug 01 '13 at 01:28

score 1 · Answer 2 · answered Aug 01 '13 at 01:07

1

select Skill, Max(SkillLevel)
from Skills
group by Skill

answered Aug 01 '13 at 01:07

Beno

4,633
1
27
26

score 0 · Answer 3 · answered Aug 01 '13 at 01:37

0

SELECT Skill, MAX(SkillLevel) FROM Skills GROUP BY Skill;

answered Aug 01 '13 at 01:37

Jude

428
4
8

Advanced SELECT query

3 Answers3