PL/SQL Where

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

Course table

COURSE_ID NAME DESCRIPTION DURATION PRICE
1 SQL 1 SQL course for beginners 1 week 10
2 SQL 2 SQL course for advanced 2 week 50
3 HTML5 Learn HTML 5 1 week 10
4 PHP PHP course 4 week 75
5 CSS Learn CSS 2 week 20

Where example

 
SELECT * FROM course WHERE price=10;

Output

COURSE_ID NAME DESCRIPTION DURATION PRICE
1 SQL 1 SQL course for beginners 1 week 10
3 HTML5 Learn HTML 5 1 week 10

Where example

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

Output

COURSE_ID NAME DESCRIPTION DURATION PRICE
2 SQL 2 SQL course for advanced 2 week 50