Question

How can you eliminate duplicate records in table with select query.

Answer 1

Answer:

sorry I didn't know the answer

Answer 2

hyy, here the answer

ANSWER:-

The go to solution for removing duplicate rows from your result sets is to include the distinct keyword in your select statement. It tells the query engine to remove duplicates to produce a result set in which every row is unique. The group by clause can also be used to remove duplicates.