Embedded Files
Filtering rows with "OR" operator
Filtering rows with "OR" operator
SELECT Name, Continent, Population
FROM country
WHERE Population < 100000
OR Population IS NULL
ORDER BY Population DESC;
Filtering rows with "AND" operator
Filtering rows with "AND" operator
SELECT Name, Continent, Population
FROM country
WHERE Population < 100000
AND Continent = "Oceania"
ORDER BY Population DESC;
Filtering rows with "LIKE" operator
Filtering rows with "LIKE" operator
SELECT Name, Continent, Population
FROM country
WHERE Name LIKE "%island%"
AND Population NOT NULL
ORDER BY Name;
Filtering rows with "LIKE" operator and matching string character
Filtering rows with "LIKE" operator and matching string character
SELECT Name, Continent, Population
FROM country
WHERE Name LIKE "_a%" # second character is "a"
AND Population NOT NULL
ORDER BY Name
Filtering rows with "IN" operator
Filtering rows with "IN" operator
SELECT Name, Continent, Population
FROM country
WHERE Continent IN ('Asia', 'Europe')
AND Population NOT NULL
ORDER BY Name
Google Sites
Report abuse