Finding/removing duplicate values from database using sql

[rajasri]

Today we are going to learn how to exclude/remove the duplicate values from database.This is useful when you want to exclude the duplicate values and show only values that can't be repeated in dropdownbox or whatever use.
There is a nice query out there look below
"select * from tablename group by fieldname having(count(*)>1)"
Here the values same more than once are excluded,any doubt comment us.

Happy coding