MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Use Subqueries with the EXISTS Operators in MS SQL Server?

Answer:

A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from ggl_links table that there are rows existing in the ggl_rates table with the same id.

SELECT id, url, tag, YEAR(created) As year
FROM ggl_links WHERE EXISTS (
SELECT * FROM ggl_rates
WHERE ggl_rates.id = ggl_links.id)
GO

id url tag Year
101 www.globalguideline.com main 2006
102 www.globalguideline.com/html DBA 2007
103 www.globalguideline.com/sql SQL 2007

Note that the subquery uses columns from the source table of the outer query.

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To Use Subqueries with the IN Operators in MS SQL Server?How To Use Subqueries in the FROM Clause in MS SQL Server?