how to retrieve only duplicate values in a table

Answer Posted / vijay_1994

select count (column_name),column_name from table_name group by column_name having count(column_name)>1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a variable in sql?

518


What is having clause in sql?

529


How would you reference column values before and after you have inserted and deleted triggers?

624


What is a full join sql?

596


What is meant by <> in sql?

511






What is cold data?

507


List the various privileges that a user can grant to another user?

586


Which are the different types of indexes in sql?

563


What is sp_helptext?

592


Explain the uses of a database trigger?

575


What are the different parts of a package?

635


How can you get sql*loader to commit only at the end of the load file? : aql loader

556


What is the difference between inner join and left join?

550


Can we insert in sql function?

551


What is full join?

534