AWS 페이지 너무 리뉴얼? 됨;; 언제 사라질지 몰라 복사~
구문
SELECT expression [, ...]
FROM table[.index]
[ WHERE condition ] [ [ORDER BY key [DESC|ASC] , ...]
다양한 예제
SELECT *
FROM Orders
WHERE OrderID = 100
SELECT *
FROM Orders
WHERE OrderID = 100 and Address='some address'
SELECT *
FROM Orders
WHERE OrderID = 100 or pk = 200
SELECT *
FROM Orders
WHERE OrderID IN [100, 300, 234]
SELECT *
FROM Orders
WHERE OrderID > 1
SELECT *
FROM Orders
WHERE Address='some address'
SELECT *
FROM Orders
WHERE OrderID = 100 OR Address='some address'
SELECT OrderID, Total
FROM Orders
WHERE OrderID = 1
SELECT OrderID, Total
FROM Orders
WHERE OrderID = 1 OR OrderID = 2
SELECT OrderID, Total
FROM Orders
WHERE OrderID IN [1, 2, 3] ORDER BY OrderID DESC
SELECT OrderID, Total
FROM Orders
WHERE Total > 500
SELECT OrderID, Total
FROM Orders
WHERE Total IN [500, 600]
SELECT OrderID, Total
FROM Orders
WHERE Total BETWEEN 500 AND 600
SELECT Devices
FROM WatchList
WHERE Devices.FireStick.DateWatched[0] >= '12/12/19'
원문
'프로그래머 > 프로그래밍' 카테고리의 다른 글
python 엑셀 읽고, 쓰고, 분석 (0) | 2022.12.02 |
---|---|
Anaconda 정의 및 기본 명령어 (0) | 2022.12.01 |
MariaDB 쿼리 계획(실행 계획) (0) | 2022.01.27 |
윈폼 출력창에 디버깅 출력 Debug.WriteLine() (0) | 2021.12.11 |
Visual Studio 주석 단축키 (0) | 2021.11.24 |
댓글