Q:

Write a query in SQL to find the name of the nurse who are the head of their department

hamza
Save to bookmark
|
2022-05-18
|
  165 
0

Write a query in SQL to find the name of the nurse who are the head of their department.

Sample table: nurse

 employeeid |      name       |  position  | registered |    ssn
------------+-----------------+------------+------------+-----------
        101 | Carla Espinosa  | Head Nurse | t          | 111111110
        102 | Laverne Roberts | Nurse      | t          | 222222220
        103 | Paul Flowers    | Nurse      | f          | 333333330
Sql programming,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

SELECT name AS "Name",
       POSITION AS "Position"
FROM nurse
WHERE POSITION='Head Nurse';

Sample Output:

      Name      |  Position
----------------+------------
 Carla Espinosa | Head Nurse
(1 row)

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

total answers (1)

Similar questions

need a help?

find thousands of online teachers now