SQL Query to return ID that have different deptID associated with it.

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SELECT ID FROM dbo.Table GROUP BY ID HAVING COUNT(*) > 1

MVIT Right there with Babe Points: 748 More actions · Answer 2

I guess this won't return the expected output. It will return even 40 as well which is not the desired output.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

SELECT ID FROM dbo.Table

GROUP BY ID

HAVING COUNT(DISTINCT DepartmentId) > 1

MVIT Right there with Babe Points: 748 More actions · Answer 4

Right there with Babe

Points: 748

October 25, 2011 at 10:23 am

THNKS FOR THE rEPLY

Cookies on SQLServerCentral