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 vote401 views1 answer
Space not removing from column in sql
SQL
1 vote348 views1 answer
Sql list all procedures
SQL
5 votes365 views4 answers
Change auto increment mysql
SQL
0 vote361 views2 answers
Sql join on comma separated field
SQL
0 vote388 views1 answer
Change database name psql 8
SQL
0 vote353 views1 answer
Data structures in sql
SQL
3 votes377 views1 answer
Oracle failed login attempts
SQL
5 votes392 views1 answer
Sql integer to serial
SQL
11 votes369 views3 answers
Change column name sql server management studio
SQL
1 vote349 views1 answer
Postgres get timestamp
SQL