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 vote172 views1 answer
Oracle select first result
SQL
0 vote141 views1 answer
Mysql collation for all languages
SQL
0 vote216 views1 answer
Find wordpress version in database
SQL
0 vote182 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote211 views1 answer
Sql create table with references not primary key
SQL
1 vote183 views1 answer
Tsql find foreign key references
SQL
1 vote172 views1 answer
Database Queries
SQL
1 vote177 views1 answer
Sql delete all values in a column
SQL
13 votes186 views1 answer
Views in sql
SQL
0 vote200 views1 answer
Create query in where clasue
SQL