How can you eliminate duplicate records in table with select query.
Answers
Answered by
0
Answer:
sorry I didn't know the answer
Answered by
7
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.
Similar questions