Praveen Kumar
SQL Query Question
By Praveen Kumar in SQL on Aug 25 2009
  • Pankaj  Kumar Choudhary
    May, 2015 21

    select Count(Dept) as No_Of_Emp,Dept from Emp Group By(Dept) Order by Dept DEsc

    • 0
  • Ashu Dhaundiyal
    Feb, 2015 21

    Select dept, count(dept) from emp group by Dept

    • 0
  • hariom
    Sep, 2010 6

    when developer get issue then its a bug.

    when tester got an issue then its a error

    and when production side got any issue tne its a defect.

    • 0
  • yakoob pasha
    Jul, 2010 29

    select dept,count(empid) as 'No of Employees' from tablename

    group by dept order by empid desc

    • 0
  • C# Curator
    Aug, 2009 25

    select dept, count(*) from emp group by dept order by dept desc

    • 0
  • Praveen Kumar
    Aug, 2009 25

    Write a query based on the below records in the table

    Empid         Empname      Dept
    1                 Praveen         IT
    2                 Mahesh         IT
    3                 Scott             HR
    4                  Leslie           Admin
    5                  Mary            HR

    Write a SQL query which returns the following result

    Dept                 No of Employees

    IT                     2
    HR                   2
    Admin              1

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS