SQL - Multiple Conditions using the AND and OR conditions

Author: databasedev.co.uk | Published: 3rd Feb 2006 | Visited: 346 times | Add Comment
Filed in: MS Access

SQL - Multiple Conditions using the AND and OR conditions: In the previous article, Using the WHERE clause with the SQL SELECT Statement, we demonstrated how you would use the SQL WHERE clause to conditionally select data from the database table. The WHERE clause can be simple and use only a single condition (like the one presented in the previous article), or it can be used to include multiple search conditions. SQL allows us to combine two or more simple conditions by using the AND and OR or NOT operators. Any number of simple conditions can be present in a single SQL statement, to allow us to create complex WHERE clauses that allow us to control which rows are included in our query results......

Read Article

Sponsored Links

• Overriding App.Config Settings for Multiple Objects One method for loading common and object-specific data from your app.config f ...

• A simplified non topic based Event Notification Server in wcf with multiple protocol support. To be notified when an alert is generated in a system without filtering for what type of event you are registe ...

• Multiple File Upload User Control This article describes how to create an user control with event & propert ...

• [AWS:EC2] Preparing For EC2 Persistent Storage: Redundant Disk Storage Across Multiple EC2 Nodes *To... So as Jeff Barr recently pointed out over on the Amazon Web Services blog, Amazon Web Services Blog: Redundant Disk Storage Across Multiple EC2 XML Hacker M. David Peterson has put together a really interesting article. As part of hi ...

• Fast ASP.NET web page loading by downloading multiple javascripts after visible content and in batch Download all external scripts on your web page after the visible content is loaded for faster perceived speed and donwload multiple javascript in batch for better actual s ...

• Faster web page loading by defering and combining multiple external javascripts into one Download all external scripts on your web page after the visible content is loaded for faster perceived speed and donwload multiple javascript in batch for better actual s ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• Managing multiple subscriptions in PHP Use PHP and MySQL in your Dreamweaver site to enable customers to manage multiple newsletter subscripti ...

• Looking up items in HashTable/Dictionary objects that have multiple keys Dictionary objects take a single string as look up key. This class simplifies using a Dictionary when you have multiple keys, such as two strings and an int, ...

• Multiple Ways to do Multiple Inserts Various ways to do Multiple Inserts in SQL Server 2000/2005 or Oracle Database using ADO.NET in single database round t ...

Next: Using the WHERE clause with the SQL SELECT Statement