FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
FROM table_name
Example of AND,OR & NOT operator
s_id
|
s_Name
|
age
|
salary
|
101
|
Dashzin
|
15
|
5000
|
102
|
Ravi
|
17
|
4000
|
103
|
Abhinav
|
17
|
7000
|
104
|
Ankit
|
22
|
4000
|
Example of AND operator
AND operator is used to set multiple conditions with Where clause.
s_id
|
s_Name
|
age
|
salary
|
104
|
Ankit
|
22
|
4000
|
Example of OR operator
AND operator is used to set multiple conditions with Where clause.
s_id
|
s_Name
|
age
|
salary
|
102
|
Ravi
|
18
|
4000
|
104
|
Ankit
|
22
|
4000
|
Example of NOT operator
AND operator is used to set multiple conditions with Where clause.
s_id
|
s_Name
|
age
|
salary
|
102
|
Ravi
|
17
|
4000
|
103
|
Abhinav
|
17
|
7000
|
104
|
Ankit
|
22
|
4000
|
0 comments:
Post a Comment