How to Eliminate Duplicate Rows into Result Set in SQL
In this article I am going to explain how to eliminate duplicate rows into Result Set
In this article I am going to explain about how to eliminate duplicate rows in result set. When we write any statement it show all rows in result set which satisfy WHERE condition. There are many situation where database table have duplicate rows and it shows in result set. So we need to eliminate these rows from result set. To eliminate these rows we use DISTINCT keyword in SELECT clause.
A SELECT Statement that returns all rows in result set
A SELECT Statement that eliminate duplicate rows in result set