sql - Advanced SELECT query -

this question has answer here:

• fetch row has max value column 32 answers

here's example of table:

skill | skilllevel

1 | 1

1 | 2

1 | 3

2 | 1

2 | 2

3 | 1

3 | 2

3 | 3

3 | 4

so, want write query returns me skill 1 skilllevel 3, skill 2 skilllevel 2 , skill 3 skilllevel 4 - moreover, select query select 1 row of each skill, 1 highest skilllevel. in 1 query, i'm clueless.

thanks in advance

edit: table contains 200 different skills.

select skill, max(skilllevel) table_name group skill 

put of skills groups. take max each group. put correct table name have "table_name". returns pairs made of:

1. a skill
2. and max skill level skill.