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')
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.