Ans.
ALTER TABLE [dbo].[Table2] WITH CHECK ADD FOREIGN KEY([Dept_Id])
REFERENCES [dbo].[Table1] ([Dept_Id])
ALTER TABLE [dbo].[Table2] WITH CHECK ADD FOREIGN KEY([Dept_Id])
REFERENCES [dbo].[Table1] ([Dept_Id])
SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS ( SELECT ...
No comments:
Post a Comment