如果两个员工有相同的名字和Dob我需要那些有相同名字和Dob的记录 [英] If Two Employees Have Same Name And Dob I Need Those Records Who Have Same Name And Dob

问题描述

我有一个包含不同字段的表，如firstname，lastname，DOB，EmpID，State，City



现在我需要获取具有相同名字的记录，姓氏和DOB。



请帮忙。



假设两个员工有相同的名字，我需要帮助那些具有相同名称的记录和DOB

i have a table with different fields like firstname, lastname, DOB, EmpID , State ,City

now i need to get the records who have same firstname, lastname and DOB.

please help.

suppose if two employees have same name and dob i need those records who have same name and DOB

推荐答案

这样的事情可以帮助 -

Something like this can help-

SELECT E1.Firstname, E1.Lastname, E1.DOB, EmpID , [State] ,City
FROM Employees E1
INNER JOIN 
(
	SELECT Firstname, Lastname, DOB,COUNT(Firstname)
	FROM Employees
	GROUP BY Firstname, Lastname, DOB
	HAVING COUNT(Firstname)>1
) AS E2 
ON E1.Firstname=E2.Firstname AND E1.Lastname=E2.Lastname AND E1.DOB=E2.DOB
--ORDER BY  E1.Firstname, E1.Lastname, E1.DOB, EmpID 

如果您需要进一步的帮助，请告诉我。



希望，它有帮助：）

In case, you need further help please let me know.

Hope, it helps :)

尝试：

Try:

SELECT FirstName, LastName, DOB
FROM MyTable
GROUP BY FirstName, LastName, DOB
HAVING COUNT(FirstName) > 1

这篇关于如果两个员工有相同的名字和Dob我需要那些有相同名字和Dob的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！