Select With Where Clause

Description: The WHERE clause is used to screen or filter records for specific matches.

SELECT * FROM <table_name> WHERE (some condition)
 
SELECT *
FROM <table_name>
WHERE last_name = 'Rogers';
 
SELECT *
FROM <table_name>
WHERE last_name = 'Rogers'
AND first_name = 'Mike';
 
 
SELECT *
FROM <table_name>
WHERE birth_date = '1965-01-01';

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.