Tieto Interview Question

SQL query to find department wise count

Interview Answers

Anonymous

Aug 20, 2019

SELECT emp_dept, COUNT(*) FROM emp_details GROUP BY emp_dept;

Anonymous

Aug 20, 2019

SELECT emp_dept, COUNT(*) FROM emp_details GROUP BY emp_dept;

Anonymous

Aug 20, 2019

SELECT emp_dept, COUNT(*) FROM emp_details GROUP BY emp_dept;