SQL WHERE IN clause - Database Programming

Welcome Guest

Search | Active Topics | Members | Log In | Register

Developer Forum » Software Engineering and Information Technology » Database Programming » SQL WHERE IN clause

SQL WHERE IN clause

Options · View

Previous Topic · Next Topic

hong

Posted: Tuesday, September 14, 2010 9:46:07 PM

Rank: Administration
Groups: Administration

Joined: 11/23/2008
Posts: 335
Points: 711
Location: Australia

WHERE IN is used to compare one value to several. It's more efficient than multiple select statements or multiple condition tests. It can use literal values, for example:

Code:

SELECT schoolName, city
FROM schools
WHERE city IN ('Melbourne', 'Sydney', 'Canberra', 'Brisbane')

Code:

SELECT * FROM customers WHERE customerId IN (1, 10, 100)

IN clause can be a sub query:

Code:

SELECT * FROM customers WHERE customerId IN (SELECT OrderNumber FROM Orders WHERE orderQuantity > 10)

Related:
EXISTS Returns true if a subquery contains any rows, for example:

Code:

SELECT * FROM customers WHERE EXISTS (SELECT OrderNumber FROM Orders WHERE orderQuantity > 10)

Sponsor

Posted: Tuesday, September 14, 2010 9:46:07 PM

Users browsing this topic

Guest

Developer Forum » Software Engineering and Information Technology » Database Programming » SQL WHERE IN clause

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS :

ASPNET Theme created by Boskone (Dan Ferguson)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.203 seconds.