query to find number of employees under each manager

by

I imagine you want this:

select Manager_Name, count(Name)
from Employee
group by Manager_Name

More Related Contents:

  1. Simplest way to do a recursive self-join?
  2. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  3. Explanation of self-joins
  4. What is SELF JOIN and when would you use it? [duplicate]
  5. What is a self join for? (in english)
  6. combinations (not permutations) from cross join in sql
  7. SQL Server dynamic PIVOT query?
  8. Is SELECT or INSERT in a function prone to race conditions?
  9. MySQL get row position in ORDER BY
  10. SQL Server Process Queue Race Condition
  11. Oracle SQL: Update a table with data from another table
  12. MySQL unknown column in ON clause
  13. SQL Server 2005 Pivot on Unknown Number of Columns
  14. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  15. Using Stored Procedure in Classical ASP .. execute and get results
  16. SQL – Subtracting a depleting value from rows
  17. Stored procedure or function expects parameter which is not supplied
  18. SQL Server Convert Varchar to Datetime
  19. How do I implement pagination in SQL for MS Access?
  20. What is the difference between SQL, PL-SQL and T-SQL?
  21. Export specific rows from a PostgreSQL table as INSERT SQL script
  22. Create a SQL query to retrieve most recent records
  23. How do I edit a table in order to enable CASCADE DELETE?
  24. SQL to add column with default value – Access 2003
  25. Creating temporary database that works across maven test phases?
  26. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  27. Oracle (Old?) Joins – A tool/script for conversion?
  28. How to aggregate over rolling time window with groups in Spark
  29. SQL Server search using like while ignoring blank spaces
  30. Oracle date “Between” Query

Leave a Comment