The BETWEEN operator selects values within a range. The values can be numbers, text, or dates.
1. Between Number
Syntax :-
SELECT * FROM table_name
WHERE column_name BETWEEN value1 and value2;
Example :-
SELECT * FROM new_tab
WHERE stu_id BETWEEN 6 and 8;
Solve Example :-
1. Between Number
Syntax :-
SELECT * FROM table_name
WHERE column_name BETWEEN value1 and value2;
Example :-
SELECT * FROM new_tab
WHERE stu_id BETWEEN 6 and 8;
Solve Example :-
s.PNG)
%20in%20Finance).jpg)
Posts
0 Comments:
Post a Comment