BETWEEN Command in SQL

January 10, 2009 - Posted by admin

BETWEEN command in SQL is used to select a values between ranges in the field itself .Suppose there is a list of students in the class. They are 60 in number and all their details are stored in the Database according to alphabetical order


Suppose if you want to see who have scored between 60 and 75

you can use this simple SQL  command  “SELECT * FROM  STUDENTS WHERE  MARK BETWEEN 60 AND 75″;

When you execute this command this command will show you list of students who have scored between 60 and 75 which includes the two  values also (60 and 75)

This entry was posted on Saturday, January 10th, 2009 at 11:25 am and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

Post a Comment