SQL AND/OR Operator

English | French | Portugese | German | Italian

|

|

|

|

|

HTML Tutorials

TCP/IP Tutorial

XML Tutorials

Schema Tutorial

XForms Tutorial

XSL-FO Tutorial

XML DOM Tutorial

XQuery Tutorial

XPointer Tutorial

Web Services Tutorial

Browser Scripting

JavaScript Tutorial

VBScript Tutorial

HTML DOM Tutorial

WMLScript Tutorial

Server Scripting

.NET (dotnet)

XML Web Services

Multimedia

Web Building

Java Tutorials

Servlets Tutorial

Struts Tutorial

Programming Langauges

Visual Basic Tutorial

Data Structures Using C

Soft Skills

Communication Skills

Time Management

Project Management

Leadership Skills

Corporate Communication

Negotiation Skills

SQL AND/OR Operator

Previous

Next

SQL And Or Operator

WHERE keyword might be used to conditionally select data from a table. This condition can be a simple condition or it can be a compound condition.Compound conditions are made up of multiple simple conditions connected by AND/OR. There is no limit to the number of conditions that can be present in a single SQL statement.

Syntax of Compound condition

SELECT "column_name"
FROM "table_name"
WHERE "simple condition"
{[AND|OR] "simple condition"}+

Note:-The {}+ means that the expression inside the bracket will occur one or many times.AND and OR can be used interchangeably. In addition,to indicate the order of the condition we may use the parenthesis sign ().

e.g. we may wish to select all store_name with sales greater than $1,000 or all stores with sales less than $500 but greater than $275 in Table Store_Information,

Store_name	Sales	Date
Los Angeles	$1500	Jan-05-2005
San Diego	$250	Jan-07-2005
Los Angeles	$300	Jan-08-2005
Boston	$700	Jan-08-2005

For selecting the store_name following Query:

SELECT store_name FROM Store_Information WHERE Sales > 1000 OR (Sales < 500 AND Sales > 275)

Output

store_name

Los Angeles

San Francisco

Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.

Previous

Next

Keywords sql server, sql tutorial, sql statement, sql select

HTML Quizes

XML Quizes

Web Services Quiz

Browser Scripting Quizes

JavaScript Quiz

Server Scripting Quizes

.NET (dotnet) Quizes

Microsoft.Net Quiz

XML Web Services Quiz

.Net Mobile Quiz

C# : C Sharp Quiz

Multimedia Quizes

Web Building Quizes

Web Browsers Quiz

Web Hosting Quiz

Web Building Quiz

Web Quality Quiz

Web Semantic Quiz

Web Careers Quiz

Java Quizes

Programming Langauges Quizes

Visual Basic Quiz

Data Structures Using C Quiz

Soft Skills Quizes

Communication Skills Quiz

Time Management Quiz

Project Management Quiz

Leadership Skills Quiz

Corporate Communication Quiz

Negotiation Skills Quiz

Copyright � 2003-2008 Vyom Technosoft Pvt. Ltd., All Rights Reserved.