SQL BETWEEN - Overview, syntax

          

SQL BETWEEN - Overview, syntax


SQL BETWEEN - Introduction and syntax

<<Previous  Next>>

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

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

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.

Syntax:
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2


SQL CREATE VIEW

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

SQL GROUP BY

GROUP BY: It is used with aggregate functions to group the result-set by one or more columns................

SQL IN

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

SQL LIKE

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

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

<<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