23 Nov 2013
Operators in SQL Server
- Conditional Operators:- =, <, >, <=, >=, <>, !=, !>, !<
- Example:
- Select * from emp where id=1
- Select * from emp where salary > 9000
- Logical Operators:- and, or, not, between, like, in, all, any, some
- Example:
- Select * from emp where salary>999 and city=”Chandigarh”;
- Select * from emp where salary > 9000 or city=”Chandigarh”;
- Select * from emp where city != “Chandigarh”;
- Select * from emp where salary between 5000 and 10000;
- Select * from emp where name like ‘a%’;
- Select * from emp where name like ‘_a%’;
- Select * from emp where name like ‘%a%’;
- Select * from emp where id in(4,45,54);
- select * from emp where EmpDeptId > all (select min(DeptId) from Dept)
- select name from product where productSubcategoryID = ANY (select productSubcategoryID FROM productSubcategory where name = ‘toys’)
- select * from item where price > some (select min(price) from item)
- Others:- Exists
- IF EXISTS(SELECT id FROM emp WHERE id=55)
BEG
IN
SELECT name FROm emp WHERE id=55
END
ELSE
BEGIN
PRINT ‘not exist’
END
Note:- Both Condition should be satisfied.
Note:- Either one condition should be satisfied.
Note:- Except Chandigarh employees, all others will display.
Note:- first char a and anything after that
Note:- one char before a and anything after that
//a anywhere
Note:- Select with random ids.
About Author
bestonetechnologies
I am a software developer.