Sql exists

If exists sql server

IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName ='xxxxxxxx') 
BEGIN
   SELECT 1 
END
ELSE
BEGIN
    SELECT 2
END

Source: stackoverflow.com

Sql exists

Checks for the existence of any record within the subquery, returning true if
one or more records are returned.
Example: Lists any dealerships with a deal finance percentage less than 10.
SELECT dealership_name
FROM dealerships
WHERE EXISTS (SELECT deal_name FROM deals WHERE
dealership_id = deals.dealership_id AND finance_
percentage < 10);

Similar codes

2 votes196 views1 answer
How to check if a row is null in sql
SQL
12 votes190 views3 answers
Install sqlite driver ubuntu
SQL
0 vote186 views1 answer
Sql delete where x or y or z
SQL
4 votes193 views1 answer
Find tables with column name in sql
SQL
244 votes500 views14 answers
Sql n insert
SQL
9 votes213 views4 answers
Mysql set id auto increment
SQL
5 votes237 views1 answer
Ascending order and where in sql
SQL
0 vote196 views1 answer
Add plugins to mysql workbench
SQL
1 vote208 views1 answer
Sql find column name like
SQL
2 votes237 views1 answer
Pandas to sql index
SQL