Or Operator – SQL Server Syntax Example: Or Operator – T-SQL Example

3-Minute Video Tour of LearnVisualStudio.NET by Bob Tabor


Learn Visual Studio Video Tour



Ideal Tools Organizer


Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

Or Operator – SQL Server Syntax Example: Or Operator – T-SQL Example

Purpose: – Illustrates the for .

SYNTAX:

SELECT [ ALL | DISTINCT ]
[TOP ( expression ) [PERCENT] [ WITH TIES ] ]
column_list
[ INTO new_table ]
[ FROM { table_source } [ ,...n ] ]
[ WHERE expression1 OR expression2
[ GROUP BY ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ]

PURPOSE:
Returns true or false as the result of combining two expressions.

 

NOTE: When AND and OR are used in a condition,AND takes precedence over OR.

 

Code Sample for OR operator:

 T-SQL |   |? 
 
/* Or example from http://idealprogrammer.com 
 
 PURPOSE: Returns true or false as the result of combining two expressions
 
 SYNTAX: expression1 OR expression2
 
 
 NOTE: When AND and OR are used in a condition,AND takes precedence over OR.
 
 SELECT [ ALL | DISTINCT ] 
			[TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
			 column_list  
			[ INTO new_table ] 
			[ FROM { table_source } [ ,...n ] ] 
			[ WHERE expression1 OR expression2] 
			[ GROUP BY ] 
			[ HAVING  search_condition  ] 
			[ ORDER BY  order_expression [ ASC | DESC ] ] 
*/
 
 
CREATE TABLE people(
     ID          INT,
     firstname   VARCHAR (20),
     lastname    VARCHAR (20),
     statecode   VARCHAR (2),
     alive       BIT,
     height      INT )
 GO
 
 
 
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive) --height is null 
 VALUES (1,  'Paul', 'Revere', 'AL', 0)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height) 
 VALUES (2,  'Pat', 'Lennon', 'NY', 0, 69)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height)
 VALUES (3,  'Peter', 'Martin', 'NY', 1, 75)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height)
 VALUES (4,  'George', 'Washington', 'VA', 0, 75)
 GO
 
 
 
 -- Select entire table
 SELECT 'Entire Table', * FROM people
 
 -- 1. Example of using OR with parentheses
 
 SELECT 'Example #1' AS Example, firstname, lastname, height 
  FROM people p
  WHERE (firstname = 'Paul' and lastname = 'Revere')
  OR (firstname = 'George' and lastname = 'Washington')
 
 GO
 
 -- 2. Example of OR in simple query
 
DECLARE @BIT BIT   
SET @BIT = 1 
 
SELECT 'Example #2' AS Example, @BIT AS BIT
WHERE @BIT = 0 OR @BIT = 1
 
 
 
 
 DROP TABLE people;
 
 GO
 
 
 
 

Sample Output for OR operator Example

SQL Select OR operator

Related posts:

  1. Operator Precedence – SQL Server Syntax Example: Operator Precedence – T-SQL Example Operator Precedence - SQL Server Syntax Example: Operator Precedence -...
  2. Operators – SQL Server Syntax Example: Operators – T-SQL Example Operators - SQL Server Syntax Example: Operators - T-SQL Example...
  3. IN – SQL Server Syntax Example: IN – T-SQL Example IN - SQL Server Syntax Example: IN - T-SQL Example...
  4. Logical Operators – SQL Server Syntax Example: Logical Operators – T-SQL Example Logical Operators - SQL Server Syntax Example: Logical Operators -...
  5. NOT – SQL Server Syntax Example: NOT – T-SQL Example NOT - SQL Server Syntax Example: NOT - T-SQL Example...

Related posts brought to you by Yet Another Related Posts Plugin.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net