Options

help me create UNIQUE Constraints

ducletanducletan Member Posts: 4
edited 2010-12-07 in SQL General
I want: on my table (Department_ID nvarchar(2),Possition_ID nvarchar(2))
never occur: exists

SELECT Department_ID FROM MyTable
WHERE Possition_ID = '00'
GROUP BY Department_ID HAVING COUNT(Possition_ID) >= 2
Sign In or Register to comment.