Hello guys , i am sharing between keyword with you
The BETWEEN keyword (operator) selects values within a range that can be text, numbers or dates.
The BETWEEN keyword (operator) selects values within a range that can be text, numbers or dates.
Syntax:
SELECT column1, column2 FROM
your_table_name WHERE column_name BETWEEN value1 AND value2;
Id
|
Name
|
Age
|
Address
|
1
|
Alok Kumar Singh
|
30
|
IN
|
2
|
Tomas Paul
|
45
|
NZ
|
3
|
Cristomfer Dee
|
85
|
AU
|
4
|
Niel Macengi
|
55
|
US
|
below query we are using between
keyword to get employee whose age between 20 to 50
USE SQLCLR
GO
SELECT * FROM EMPLOYEE WHERE AGE between 20 and 50
GO
Id
|
Name
|
Age
|
Address
|
Department
|
Gender
|
1
|
Alok Kumar Singh
|
30
|
IN
|
IT
|
Male
|
2
|
Tomas Paul
|
45
|
NZ
|
IT
|
Male
|
No comments:
Post a comment