관리 메뉴

moozi

sql tie score 본문

TIS_2017/응용sw_2기

sql tie score

moozi 2018. 6. 14. 14:57
SELECT
userid,
score,
  (select count(Score)+1 as position
  from yourtable
  where Score > X.Score ) as rank
  from yourtable X
ORDER BY rank


'TIS_2017 > 응용sw_2기' 카테고리의 다른 글

html연습문제03  (0) 2018.03.22
하둡연습문제02  (0) 2017.12.19
하둡연습문제01  (0) 2017.12.18
하둡 Rhadoop 관련 자료  (0) 2017.12.18
R연습문제03  (0) 2017.12.14
Comments