SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 6 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 5 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 4 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 3 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 2 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 1 ORDER BY NUM
DESC
SELECT MAX(NUM) FROM SEED_BOOK WHERE GRADE = 0 ORDER BY NUM
DESC
이쿼리를 한번에 날릴수는 없을 까요
고수님들 함 봐주세요
좀 급한거라 빨리 부탁 드립니다
|