In this post we will discuss how to get distinct data from tables in sql server 2008?
Also you can check my previous posts on:
‘Distinct’ keyword is used to eliminate duplicate values in the output of a select statement.
It can be used only once in the select statement that also immediately next to the keyword ‘select’.
Select distinct deptno from Employee
Select distinct deptno,job from Employee