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

32 votes222 views6 answers
Insert select
SQL
0 vote204 views1 answer
Sql common columns
SQL
0 vote200 views1 answer
Windows services sql
SQL
2 votes206 views2 answers
Compare date mysql
SQL
0 vote199 views1 answer
View psql output in horizontal scrolling
SQL
1 vote212 views1 answer
Sql select all from one table and one column from another
SQL
0 vote198 views1 answer
Run postgresql dump to csv
SQL
0 vote266 views1 answer
Sql server query all database objects
SQL
0 vote192 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
4 votes219 views2 answers
Truncate oracle
SQL