Subqueries & the EXISTS Predicate Subqueries in SQL Server 2016 are nested SELECT statements used to create more effective queries in T-SQL. Explore subqueries and correlated subqueries and the EXISTS predicate.