Transact SQL 101 - Lesson 04_02_SQL.txt

(0 KB) Pobierz

--NEXT VIDEO
--Using the WHERE clause
--Logical Operators


--AND 
SELECT * 
FROM saleslt.product
WHERE color = 'black' AND listprice < 50
ORDER BY color, listprice

--OR
SELECT * 
FROM saleslt.product
WHERE color = 'black' OR listprice < 50
ORDER BY color, listprice

--BETWEEN
SELECT * 
FROM saleslt.product
WHERE listprice BETWEEN 50 AND 100
ORDER BY listprice

--IN
SELECT * 
FROM saleslt.address
WHERE stateprovince IN ('Texas','Arizona')
ORDER BY stateprovince 

--LIKE
SELECT CountryRegion, StateProvince, City, AddressLine1
FROM saleslt.address
WHERE City LIKE 'C%' AND CountryRegion = 'United States'
ORDER BY CountryRegion, StateProvince, City

Transact SQL 101 - Lesson 04_02_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: