如果两个员工有相同的名字和Dob我需要那些有相同名字和Dob的记录 [英] If Two Employees Have Same Name And Dob I Need Those Records Who Have Same Name And Dob
本文介绍了如果两个员工有相同的名字和Dob我需要那些有相同名字和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屋!
查看全文