Q:

Write a query in SQL to find all the information of the nurses who are yet to be registered

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

 Write a query in SQL to find all the information of the nurses who are yet to be registered.

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 *
FROM nurse
WHERE registered='false';

Sample Output:

  employeeid |     name     | position | registered |    ssn
 ------------+--------------+----------+------------+-----------
         103 | Paul Flowers | Nurse    | f          | 333333330
 (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