SQL - Retrieve all students between the ages of 18 and 22 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

SQL - Retrieve all students between the ages of 18 and 22

How to retrieve all students between the ages of 18 and 22 when using SQL?

19th Dec 2016, 5:01 PM
Alejandro Fernández Trigo
Alejandro Fernández Trigo - avatar
8 Answers
+ 5
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
26th Feb 2018, 11:57 AM
Salman Aziz
Salman Aziz - avatar
+ 2
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
25th Apr 2020, 6:43 AM
Akshita Patidar
Akshita Patidar - avatar
+ 1
SELECT * FROM students WHERE age BETWEEN 18 AND 22;
19th Dec 2016, 5:04 PM
jonba
+ 1
SELECT name FROMstudents WHERE age BETWEEN 18 AND 22;
25th Apr 2020, 6:40 AM
VIDHAN JAIN
VIDHAN JAIN - avatar
0
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
10th Apr 2018, 10:36 AM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
0
SELECT-WHERE-AVG
8th Apr 2020, 10:17 PM
Mobin Mirarab
Mobin Mirarab - avatar
0
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
11th Sep 2020, 8:09 PM
OjeifoIduma
- 1
This question got me stuck. Has to start with a FROM (like SELECT name FROM students) then is where I'm lost.
19th Dec 2016, 5:05 PM
Alejandro Fernández Trigo
Alejandro Fernández Trigo - avatar