SQL IN - Overview, syntax


SQL IN - Overview, syntax

SQL IN - Introduction and syntax

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL IN statement. Write SQL syntax for the SQL IN statement along with an example.

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

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

SELECT * FROM employee
WHERE emp_LastName IN ('james','jones')


SQL BETWEEN: The BETWEEN operator is used in a WHERE clause to select a range of data between two values. The values can be numbers, text, or dates..............


SQL CREATE VIEW: A view is a virtual table. A view contains rows and columns, just like a real table..............


LIKE clause is used for pattern matching. % is used to match any string of any length where as _ allows you to match on a single character................


SQL NOT NULL: The NOT NULL constraint enforces a column to NOT accept NULL values..............

Explain the SQL UNION ALL statement. Write SQL syntax for the SQL UNION ALL statement along with an example.

SQL UNION ALL: The UNION ALL operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement ................

<<Previous  Next>>

Write your comment - Share Knowledge and Experience

Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring