Snippet Name: SELECT with WHERE Clause Description: The WHERE clause is used to screen or filter records for specific matches. Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Description: The WHERE clause is used to screen or filter records for specific matches.
Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select
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';
