Transact SQL 101 - Lesson 04_01_SQL.txt

--NUMERIC
--Equal to
SELECT *
FROM saleslt.product
WHERE productid = 706

--Greater than
SELECT * 
FROM saleslt.product
WHERE listprice > 9.50
ORDER BY listprice ASC

--Greater than or equal to
SELECT * 
FROM saleslt.product
WHERE listprice >= 9.50
ORDER BY listprice ASC

--Less than
SELECT * 
FROM saleslt.product
WHERE listprice < 9.50
ORDER BY listprice DESC

--Less than or equal to
SELECT * 
FROM saleslt.product
WHERE listprice <= 9.50
ORDER BY listprice DESC

--Not equal to
SELECT * 
FROM saleslt.product
WHERE listprice <> 9.50
ORDER BY listprice DESC

--Comparing Fields
SELECT *

FROM saleslt.product
WHERE listprice <> standardcost
ORDER BY listprice DESC

--Error:  Datatypes must match
SELECT *
FROM saleslt.product
WHERE listprice > color

SELECT *
FROM saleslt.product
WHERE listprice > 1.0


--CHARACTER STRINGS
--Filter Results on a character string
SELECT *
FROM saleslt.product
WHERE color = 'black' --nvarchar character

SELECT *
FROM saleslt.product
WHERE size = 'M' -- size column is nvarchar

SELECT *
FROM saleslt.product
WHERE size = '58' -- size column is nvarchar

--DATES
SELECT * 
FROM saleslt.product
WHERE sellstartdate > '6/1/1998' 
ORDER BY sellstartdate ASC

SELECT * 
FROM saleslt.product
WHERE sellstartdate <= '6/1/1998'
ORDER BY sellstartdate ASC

SELECT * 
FROM saleslt.product
WHERE sellstartdate <> '6/1/1998'
ORDER BY sellstartdate ASC