mysql 기본 예제를 통한 기본 문법 살펴보기(개인 학습용)

use cookdb;

--order by 문법을 사용해서 해당 열을 정렬한다
--만약에 desc이면 내림차순 asc 오름차순으로 정렬한다.
select username, mdate from usertbl order by mdate;
select username, mdate from usertbl order by mdate desc;
select username, height from usertbl order by height ;
select username, height from usertbl order by height desc;

select distinct addr from usertbl order by addr;

 

SELECT 
    birth_date
FROM
    employees
WHERE
    birth_date BETWEEN '1960-01-01' AND '1969-12-31'
ORDER BY birth_date DESC; 

--where문은 조건을 지정해주는 것이며, BETWEEN '1960-01-01' AND '1969-12-31