일 얘기
Ranking 쿼리
자유로
2005. 1. 12. 19:32
CREATE VIEW vw_Test
AS
SELECT user_id, score, (SELECT Count(*) FROM Test WHERE score >= T.score) AS rank
FROM Test T
GO
AS
SELECT user_id, score, (SELECT Count(*) FROM Test WHERE score >= T.score) AS rank
FROM Test T
GO