Q:

Write a mysql statement to select data of only students with age either in 22,23,24 and department is 'EC'

belongs to collection: MySQL Exercises

YasminRadwan26
Save to bookmark
|
2022-05-14
|
  340 
0

MySQL Where Clause Exercise

Write a mysql statement to select data of only students with age either in 22,23,24 and department is 'EC'

Suppose the table is -

+----+--------------+------------+-----+
| id | name         | department | age |
+----+--------------+------------+-----+
|  1 | Maria Gloria | CS         |  22 |
|  2 | John Smith   | IT         |  23 |
|  3 | Gal Rao      | CS         |  22 |
|  4 | Jakey Smith  | EC         |  24 |
|  5 | Rama Saho    | IT         |  22 |
|  6 | Maria Gaga   | EC         |  23 |
+----+--------------+------------+-----+
Sql programming,
login and add your own answer to this question

All Answers

YasminRadwan26
2022-05-14
need an explanation for this answer? contact us directly to get an explanation for this answer

The following statement is used to select data of only students with age either in 22,23,24 and department is 'EC'.

mysql> SELECT id, name, department, age FROM students
    -> WHERE age IN(22,23,24) AND department = 'EC';

Output of the above statement -

+----+--------------+------------+-----+
| id | name         | department | age |
+----+--------------+------------+-----+
|  4 | Jakey Smith  | EC         |  24 |
|  6 | Maria Gaga   | EC         |  23 |
+----+--------------+------------+-----+

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

MySQL Exercises
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
Write a MySQL statement to select data of all depa... >>
<< Write a mysql statement to select data of only stu...