hi ,
I am getting duplicate values . but i used distinct still getting duplicates
please help me
SELECT DISTINCT p.EmployeeId,p.ProjectEmployeeId,
p.StartDate,
p.EndDate,
p.AllocationPercentage,
CONCAT(e.FirstName,' ', e.LastName)AS EmployeeName
FROM projectemployee p
LEFT OUTER JOIN employee e ON p.EmployeeId=e.EmployeeId
WHERE CURDATE() NOT BETWEEN p.StartDate AND p.EndDate OR p.AllocationPercentage <100
ORDER BY e.FirstName ASC;
Ravi KumarPosted Nov 4, 2015, 7:11 AM
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
Jignesh TrivediPosted Nov 4, 2015, 11:32 PM
padmapriya patruniPosted Nov 4, 2015, 11:08 PM
Upendra Pratap ShahiPosted Nov 4, 2015, 7:45 AM
SELECT UserId,COUNT(*) as TotalCount FROM user_tbl GROUP BY UserId HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC;