Friday, June 1, 2012

SQL IN Operator

The IN operator allows you to specify multiple values in a WHERE clause


SQL IN Syntax
SELECT coulmn_name (s) FROM table_name
WHERE column_name IN (value1, value2,....)


SQL IN Example
SELECT * FROM Employee
WHERE EmpName IN ('Dravid','Sourav')

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.