What is syntax for SQL-Server BETWEEN operator?

Posted by vishalneeraj-24503 on 12/18/2013 | Category: Sql Server Interview questions | Views: 1720 | Points: 40

Answer:

SELECT column_name
From table_name
Where column_name
BETWEEN value1 AND value2;

For Example:-

Select employee_name,employee_code

From Employee_Master

Where Employee_Id

Between 200 And 250;

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to get the Host Name of a computer?

Next > : What will be the output of below code? int tota ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions