Mysql
[Mysql] - 중복된값 제거 쿼리예제
Vivara
2011. 7. 13. 09:25
반응형
사용법
/*** Query Start ***/
SELECT DISTINCT NUMBER
FROM ABCD
ORDER BY NUMBER DESC
/*** Query End ***/
* 1개 컬럼에만 적용됨
ex) 아래 쿼리 적용안됨
SELECT DISTINCT NUMBER, NAME
FROM ABCD
ORDER BY NUMBER DESC
/*** Query Start ***/
SELECT DISTINCT NUMBER
FROM ABCD
ORDER BY NUMBER DESC
/*** Query End ***/
* 1개 컬럼에만 적용됨
ex) 아래 쿼리 적용안됨
SELECT DISTINCT NUMBER, NAME
FROM ABCD
ORDER BY NUMBER DESC
반응형