Essential Books

Where EXISTS

suggest change

Will select records in TableName that have records matching in TableName1. 

SELECT * FROM TableName t WHERE EXISTS (
    SELECT 1 FROM TableName1 t1 where t.Id = t1.Id)
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Filter results using WHERE and HAVING:
*Filter results using WHERE and HAVING
*Use BETWEEN to Filter Results
*Use HAVING with Aggregate Functions
*WHERE clause with NULLNOT NULL values
*The WHERE clause only returns rows that match its criteria
*Equality
*AND and OR
*Use IN to return rows with a value contained in a list
*Use LIKE to find matching strings and substrings
*Use HAVING to check for multiple conditions in a group
*Where EXISTS
Table Of Contents