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
  • 2061

Introduction

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

Clipboard22.jpg

A SELECT Statement that eliminate duplicate rows in result set

Clipboard24.jpg


© 2013 dotNetheaven. All rights reserved.