Removing duplicate records and to store in new table with single query

[PerumalSamy]

Hi

I am having table with more 13 lakhs records.

I am having duplicate records in it.

i need to remove that.

I wrote the following query
SELECT *
FROM chitta union SELECT *
FROM chitta;

its working fine and showing records after removing duplicate records

but the following query giving error
SELECT * into Table2
FROM Table1 union SELECT *
FROM Table1;

[azimmer]

Hi

I am having table with more 13 lakhs records.

I am having duplicate records in it.

i need to remove that.

I wrote the following query
SELECT *
FROM chitta union SELECT *
FROM chitta;

its working fine and showing records after removing duplicate records

but the following query giving error
SELECT * into Table2
FROM Table1 union SELECT *
FROM Table1;

Your first SELECT ... UNION doesn't make much sense: it just returns the same lines as SELECT * FROM chitta (since it is the same set as with the UNION).
If you need to remove duplicates use the DISTINCT keyword with SELECT:

SELECT DISTINCT * FROM chitta
 

or

SELECT DISTINCT * INTO Table2 FROM chitta