SQL Duplicated Row

Question

I have a duplicated row but not the same value in the all example:

Name , Group , Level
SKILL_CHAR_FRONTAREA_A_01 SKILL_CHAR_FRONTAREA_A 1
SKILL_CHAR_FRONTAREA_A_02 SKILL_CHAR_FRONTAREA_A 2

I need to select the top one between them, using the order by level desc.

i donn't need to select using first row inserted i need to select by the top 1 between them — user2684159, Jan 08 '15 at 09:51

score 0 · Answer 1 · answered Jan 08 '15 at 09:41

0

Do you mean you want the row with the lowest or highest level value?

select Name , Group , min(Level)
from yourtable
group by Name , Group

Change min to max if you want the highest level.

answered Jan 08 '15 at 09:41

jarlh

no i need to select the top 1 between them – user2684159 Jan 08 '15 at 09:45
1

Did you even try my select??? It's portable SQL, and produces the result you want! – jarlh Jan 08 '15 at 09:46
still yea http://prntscr.com/5pvc8d – user2684159 Jan 08 '15 at 09:50
@jarlh this can't works: you're grouping by name and group, but in the example names are different. So you obtain 2 rows. – Luca Davanzo Jan 08 '15 at 09:50
Oops, I didn't notice that minor difrerence. Sorry. I'll soon get back and edit my query. – jarlh Jan 08 '15 at 09:55

score 0 · Answer 2 · answered Jan 08 '15 at 09:51

0

SELECT name, GroupName, Level
FROM table
WHERE Level = '1'

answered Jan 08 '15 at 09:51

Matt

hey i need to select the top 1 between them and using order not a specify varible – user2684159 Jan 08 '15 at 09:54
The top one is always level 1 according to your screenshot you posted? – Matt Jan 08 '15 at 09:55

2 Answers2