Sunday, 20 November 2011



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

BETWEEN operator Example

Syntax:
SELECT Column_Name(s) FROM Table_Name
WHERE Column_Name BETWEEN Value1 AND Value2
Example Statement:
SQL> SELECT * FROM Student_Detail WHERE 
S_No BETWEEN 1 OR 5;
Example Result:

S_NoS_NameTotalPercentageAddressCity
1Jay50777.84BapunagarAhmedabad
2Ajay48774.92Modera Cross RoadMehsana
3Bhavesh46972.15Radhanpur Cross RoadMehsana
4Jaimin46371.23ManinagarAhmedabad
5Dolar42565.38PanchvatiAhmedabad


SQL GUIDE

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers