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

0 vote129 views1 answer
Postgresql newline character
SQL
0 vote139 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote134 views1 answer
Where date = max(date) in sql
SQL
0 vote136 views1 answer
Azure sql server check foreign key
SQL
0 vote141 views1 answer
Excel export from sql using python
SQL
0 vote136 views1 answer
Can we rollback in sql
SQL
0 vote136 views1 answer
Mod in sql
SQL
0 vote137 views1 answer
List column names of multiple tables psql
SQL
10 votes135 views1 answer
Oracle view dependencies
SQL
2 votes135 views2 answers
Created at and updated at in mysql
SQL