You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
--LIKE auxiliar na seleção de dados específicos em uma tabela, como palavras iniciadas ou terminadas com uma letra específica. % no inicio ou no final de acordo a posição da palavra.
SELECT*FROM DimProduct
WHERE ProductName LIKE '%MP3 Player%'
--BETWEEN
SELECT*FROM DimProduct
WHERE UnitPrice BETWEEN 50 AND 100
SELECT*FROM DimProduct
WHERE UnitPrice NOT BETWEEN 50 AND 100
SELECT * FROM DimEmployee
WHERE HireDate BETWEEN '2000-01-01' AND '2000-12-31'