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

3 votes371 views2 answers
How to force truncate a table in mysql
SQL
13 votes325 views2 answers
Oracle inner join
SQL
10 votes397 views4 answers
Join multiple tables in sql
SQL
2 votes401 views2 answers
MySql FULL OUTER JOIN
SQL
-1 vote356 views1 answer
Utf8_encode mysql
SQL
0 vote319 views1 answer
Lister les index d'une table oracle
SQL
0 vote341 views1 answer
Setval in postgres
SQL
1 vote261 views1 answer
Convert money to varchar sql server
SQL
0 vote412 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote335 views2 answers
MySQL top percent
SQL