//Code for remove duplicate from string
string temp = "";
finalgrp.Split(',').Distinct().ToList().ForEach(k => temp += k + ",");
finalgrp = temp.Trim(',');
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