SQL query to compare two columns in the same table

Question

I have a table where some of the data are repeating. I need to copy the repeated values from the table to a new table. Need an sql query to do this

Adinarayana Reddy Jc · Answer

Hi dhilu das try this one. create table tbl_demo(Id intName varchar(50)) create table tbl_demo1(Id intName varchar(50)) insert into tbl_demo values(1'adi') insert into tbl_demo values(1'adi') insert into tbl_demo values(1'adi') insert into tbl_demo values(1'ravi') INSERT INTO tbl_demo1 SELECT IdName FROM tbl_demo GROUP BYIdName HAVINGCOUNT(1) > 1