SQL-Learnings/FILTERING DATA.sql at main · SahaAkash-Me/SQL-Learnings · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
SELECT*
FROM customers;

SELECT *
FROM customers
WHERE country != 'Germany';

SELECT *
FROM customers
WHERE score >= '500';

										-- LOGICAL OPERATORS BELOW  'AND', 'OR', 'NOT'--
SELECT *
FROM customers
WHERE
	country = 'USA'
	AND
	score > 500;

SELECT *
FROM customers
WHERE
	country = 'USA'
	OR
	score > 500;


											    -- RANGE OPERATORS BELOW  'BETWEEN'--

SELECT *
FROM customers
WHERE score BETWEEN 100 AND 500;		-- WE CAN ALSO USE 'WHERE score >= 100 AND score <= 500'

											    -- MEMBERSHIP OPERATORS BELOW  'IN' ,  'NOT IN'--

SELECT *
FROM customers
WHERE country  IN ('Germany', 'USA');
											    -- SEARCH OPERATORS BELOW  'LIKE'--
SELECT *
FROM customers
WHERE first_name LIKE 'M%'

SELECT *
FROM customers
WHERE first_name LIKE '%n'

SELECT *
FROM customers
WHERE first_name LIKE '%r%';

SELECT *
FROM customers
WHERE first_name LIKE '__r%';