S_pot

SQL_BETWEEN ~ AND, IN(), LIKE 본문

SQL

SQL_BETWEEN ~ AND, IN(), LIKE

S_pot 2021. 5. 28. 14:37 
SELECT Name, height FROM usertbl WHERE height BETWEEN 180 AND 183; -- BETWEEN...AND

SELECT * FROM userTbl WHERE addr IN('경남', '전남', '경북'); -- IN()

SELECT Name, height FROM userTbl WHERE name LIKE '김%';

SELECT Name, height FROM userTbl WHERE name LIKE '_종신';

 

'SQL' 카테고리의 다른 글

SQL_SQL 줄번호 표시방법  (0) 2021.05.28
SQL_ANY/ALL/SOME 서브쿼리  (0) 2021.05.28
SQL_WHERE 절  (0) 2021.05.28
SQL_모델링 데이터베이스(다이어그램)  (0) 2021.05.27
SQL_백업, 복원  (0) 2021.05.27
'SQL' Related Articles more