Welcome Guest. Sign in or Signup

2 Answers

Counting Reportees under a Supervisor

Asked by: 2425 views SQL

You have a table that has two fields: EMPLID and SUPERVISOR_ID. The SUPERVISOR_ID field contains EMPLIDs of Supervisor to whom an Employee is tagged. Can you write an SQL Query that lists SUPERVISOR_IDs and Counts of reportees against each SUPERVISOR_ID?

Related Questions

2 Answers



  1. batchu on Nov 14, 2012 Reply

    yes i need answer to this question

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. KathisKumaravel on Jun 11, 2013 Reply

    select supervisorid, count(employeeid) from tablename group by supervisorid

    0 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question