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 vote138 views1 answer
How to find unique element in sql
SQL
13 votes120 views3 answers
Sql online code
SQL
0 vote106 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
27 votes118 views5 answers
Add column in table
SQL
0 vote122 views2 answers
How to update the multiple rows in sql
SQL
0 vote115 views1 answer
Change date format in oracle query
SQL
0 vote124 views1 answer
Login failed for login due to trigger execution
SQL
5 votes124 views2 answers
Sql server check port number
SQL
-1 vote128 views1 answer
Module operator in oracle sql
SQL
4 votes114 views1 answer
Find tables with column name in sql
SQL