Q:

Write a mysql statement to select data of only CS OR IT departments

belongs to collection: MySQL Exercises

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

MySQL Where Clause Exercise

Write a mysql statement to select data of only CS OR IT departments

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

Solution:

The following statement is used to get students data of CS OR IT departments only.

mysql> SELECT name, department, age FROM students
    -> WHERE department = 'CS' OR department = 'IT';

Output of the above statement -

+--------------+------------+-----+
| name         | department | age |
+--------------+------------+-----+
| Maria Gloria | CS         |  22 |
| John Smith   | IT         |  23 |
| Gal Rao      | CS         |  22 |
| Rama Saho    | IT         |  22 |
+--------------+------------+-----+

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 only stu... >>
<< Write a mysql statement to create a new user and s...