fetch_last_added_row_department_wise.sql

SELECT t1.name user_name, dep.name department, t1.created_on
FROM employee t1 JOIN department dep ON t1.department_id =dep.id
WHERE t1.created_on = (SELECT MAX(t2.created_on)
                 FROM employee t2
                 WHERE t2.department_id = t1.department_id);
                 
                 
-- If not exists in the child table               
SELECT p.id 
FROM project p 
WHERE NOT EXISTS (
    SELECT 1 FROM project_description pd
    WHERE  pd.project_id= p.id AND pd.project_service_type_id =33
) ORDER BY p.id;
                 

Department

Employee Table