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

6 votes375 views3 answers
Create database mysql utf8
SQL
4 votes338 views1 answer
Id primary key auto generated
SQL
2 votes340 views1 answer
When matched in sql server
SQL
0 vote325 views1 answer
Mysql date only no time
SQL
0 vote324 views1 answer
Acual month sql
SQL
11 votes319 views2 answers
Sql rank
SQL
-1 vote350 views2 answers
Postgresql user permissions to database
SQL
0 vote374 views1 answer
Get total and distict row diff in sql
SQL
1 vote320 views2 answers
T-sql random number for each row
SQL
1 vote349 views1 answer
Right outer vs left outer join
SQL