Tuesday, 6 August 2013

SQL INNER JOIN DISTINCT RESULT

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