Categories
Database Development

How to check if staff member has end date with a Null value

I have a database that records employees tasks throughout the organisation and when they finish etc., I need to identify if each employee, has at least one row with a null value in either finish.

Basically – show me any employee_no that does not have at least one row with a null value in column Finish.

There can be more than one null value but as long as there’s one.

Sample database:

Leave a Reply

Your email address will not be published. Required fields are marked *