PL/SQL Where

The WHERE clause is used to filter the results in a SELECT, INSERT, UPDATE or DELETE statement.

Course table

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
1SQL 1SQL course for beginners1 week10
2SQL 2SQL course for advanced2 week50
3HTML5Learn HTML 51 week10
4PHPPHP course4 week75
5CSSLearn CSS2 week20

Where example

 
SELECT * FROM course WHERE price=10;

Output

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
1SQL 1SQL course for beginners1 week10
3HTML5Learn HTML 51 week10

Where example

 
SELECT * 
FROM course 
WHERE duration = '2 weeks' 
AND price > 20; 

Output

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
2SQL 2SQL course for advanced2 week50