SQL INNER JOIN DISTINCT RESULT
I have two tables SelfAnswers and Employee . When doing the following
query:I want to return distinct result .
SELECT s.Id,s.EmployeeId,e.NAME,e. Department
FROM SelfAnswers AS s Inner Join Employee As e ON
s.EmployeeId=e.EmployeeId
Output is
Id EmployeeId NAME Department
1 100 adam Exam
2 100 adam Exam
3 100 adam Exam
4 100 adam Exam
5 101 smith Exam
6 101 smith Exam
7 101 smith Exam
8 101 smith Exam
No comments:
Post a Comment