CoderZone.org

Category: >> Oracle PL/SQL >> AND Condition Bookmark and Share

<< lastnext >>

Snippet Name: AND Condition

Description: The AND condition allows you to create an SQL statement based on 2 or more conditions being met. It can be used in any valid SQL statement - select, insert, update, or delete.

Also see:
» ORDER BY Clause
» FLASHBACK: AS OF clause
» BETWEEN Condition
» LIKE Condition
» Combining the AND and OR Conditions
» OR Condition
» WHERE Clause - Joins
» WHERE Clause - Conditions
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» UPDATE: with RETURNING clause
» INSERT With Returning Clause
» Date Functions: WHERE Clause Joins
» Having Clause
» Example WITH Clause: Single alias
» Example WITH Clause: Double alias

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

-- The syntax for the AND condition is:
 
SELECT columns
FROM tables
WHERE column1 = 'value1'
AND column2 = 'value2';
 
-- The AND condition requires that each condition be must 
-- be met for the record to be included in the result set. 
-- In this case, column1 has to equal 'value1' and column2 
-- has to equal 'value2'.
 
 
 
-- Example #1
 
-- The first example that we'll take a look at involves a very 
-- simple example using the AND condition.
 
SELECT *
FROM suppliers
WHERE city = 'New York'
AND TYPE = 'PC Manufacturer';
 
-- This would return all suppliers that reside in New York 
-- and are PC Manufacturers. Because the * is used in the select, 
-- all fields from the supplier table would appear in the result 
-- set.
 
 
 
--Example #2
 
-- Our next example demonstrates how the AND condition can be 
-- used to "join" multiple tables in an SQL statement.
 
SELECT orders.order_id, suppliers.supplier_name
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
AND suppliers.supplier_name = 'IBM';
 
-- This would return all rows where the supplier_name is IBM. 
-- And the suppliers and orders tables are joined on supplier_id. 
-- You will notice that all of the fields are prefixed with the 
-- table names (ie: orders.order_id). This is required to 
-- eliminate any ambiguity as to which field is being referenced; 
-- as the same field name can exist in both the suppliers and 
-- orders tables.
 
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7