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 vote287 views1 answer
Sql reverse order of results
SQL
2 votes283 views1 answer
Oracle list grants on package
SQL
0 vote281 views1 answer
Where field is null sql knex
SQL
0 vote284 views1 answer
How to declare variable date in mysql
SQL
7 votes279 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote278 views1 answer
Mysql update table from select on another table
SQL
0 vote279 views1 answer
Oracle sql drop table
SQL
1 vote283 views2 answers
Remove space in mysql
SQL
0 vote251 views1 answer
Linux upload database to mysql
SQL
1 vote289 views1 answer
Oracle insert multiple rows into same table
SQL