how to delete duplicate rows in sql server 2005?

Answer Posted / shashikant

distinct <column name>
from <table name>

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I completely remove mysql from windows?

454


What is database clustering in mysql?

483


How to add a new column to an existing table in mysql?

530


Is mysql a server or database?

478


What is database migration in mysql?

526






What is pdo mysql?

511


What is mysqli procedural?

527


How to determine the location of the data directory?

504


Create table employee (eno int(2),ename varchar(10)) ?

550


What is foreign key in mysql?

599


What is cast in mysql?

478


What is difference between mysql and mysqli?

487


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

501


Which is better mysql or mssql?

482


Is mysql same as sql?

491