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 vote350 views1 answer
Sql find all different values in column
SQL
0 vote362 views1 answer
Psql show db
SQL
1 vote347 views1 answer
Postgres set column equal to another
SQL
0 vote339 views1 answer
Alter table myisam to innodb
SQL
1 vote355 views1 answer
Date_part mysql
SQL
1 vote383 views1 answer
Import mysql dump database command line linux
SQL
0 vote326 views1 answer
What are the aggregate function in sql
SQL
0 vote339 views1 answer
Sql offfset
SQL
4 votes325 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
37 votes351 views3 answers
Duplicate records in sql
SQL