SQL Query Question

DELETE FROM tbBooks
WHERE BookId IN (SELECT TOP 2 BookId FROM tbBooks ORDER BY BookId ASC)

Rajeev Kumar3y

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

Pankaj Kumar Choudhary11y

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

Ashu Dhaundiyal11y

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.

hariom16y

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

group by dept order by empid desc

yakoob pasha16y

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

C# Curator17y

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

Praveen Kumar17y

SQL Query Question

7 Answers