Moving all distinct records into a new table

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 501
SELECT DISTINCT * 
INTO NewTable
FROM OldTable


SELECT ... INTO clause will copies data to new table...
DISTICNT clause removes the duplicate reocrds

Comments or Responses

Login to post response