Select
SELECT * FROM article ORDER BY hit DESC LIMIT 3;
SELECT * FROM article WHERE nickname LIKE '홍길%';
SELECT * FROM article WHERE hit >= 10 AND hit <= 55;
SELECT * FROM article WHERE hit BETWEEN 10 AND 55;
SELECT * FROM article WHERE nickname != '무명' AND hit <= 50;
SELECT * FROM article WHERE nickname = '무명' OR hit >= 55;
InnerJoin
SELECT e.index AS '사원번호',e.name AS '사원명',d.name AS '부서명'
FROM dept AS d
INNER JOIN emp AS e
ON d.index = e.deptNum
ORDER BY `부서명`,`사원명`;
LEFT/RIGHT (OUTER) JOIN
SELECT *
FROM table_A LEFT JOIN table_B
FROM table_B RIGHT JOIN table_A
SELECT *
FROM table_A RIGHT JOIN table_B