MS SQL Server Concepts and Programming Question:
Download Questions PDF

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


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
SELECT * FROM ggl_rates

id url tag Year
101 main 2006
102 DBA 2007
103 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?