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

2 votes93 views1 answer
Plsql block
SQL
0 vote98 views1 answer
How to change null display in psql
SQL
52 votes258 views6 answers
Rename column sql
SQL
0 vote114 views1 answer
Postgresql create query
SQL
5 votes98 views3 answers
Sql max value in column
SQL
25 votes115 views4 answers
Metadata
SQL
7 votes106 views2 answers
Create index mysql
SQL
1 vote97 views1 answer
Regular expression in sql server
SQL
13 votes109 views2 answers
Sql join
SQL
5 votes101 views4 answers
Describe table postgres
SQL