Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 744
Home > Codes >

List out the department id having at least four employees

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 2834
Post Code | Search Codes | Code Home  
SELECT DepartmentID 
FROM EmployeeTable
GROUP BY DepartmentID 
HAVING COUNT(*)>=4
Alert Moderator 
Bookmark It

Comments or Responses

Login to post response

Latest Code Snipptes