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

-1 vote205 views1 answer
Module operator in oracle sql
SQL
2 votes263 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote261 views1 answer
Sql database size
SQL
0 vote225 views1 answer
What is logical database schema
SQL
0 vote205 views2 answers
Oracle create tablespace autoextend
SQL
0 vote268 views1 answer
Alter database name script
SQL
0 vote187 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote187 views1 answer
What is intersect
SQL
0 vote199 views1 answer
Heidisql check how much space a row
SQL
0 vote205 views1 answer
Shows all databases created by user in ms sql
SQL