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 vote176 views1 answer
Sql order by number not ordered
SQL
11 votes284 views2 answers
Import mysql dump command line windows
SQL
11 votes162 views1 answer
Ddl view
SQL
1 vote153 views1 answer
Mysql f# examples
SQL
1 vote145 views1 answer
Mysql select month and year
SQL
0 vote149 views1 answer
Sql developer connect to sql server
SQL
5 votes147 views1 answer
How to check nls format in oracle
SQL
0 vote174 views1 answer
Sql basic commands
SQL
0 vote145 views2 answers
Default constraint in ms sql
SQL
0 vote101 views2 answers
Denormalization in sql
SQL