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

Give string types available for column?

550


How do you rename a procedure in mysql?

450


What is the difference between unix timestamps and mysql timestamps?

508


What does mysql_query return?

496


How do I quit mysql?

485






How many entries can mysql handle?

500


What is a join in mysql?

487


How do I zip a file in mysql?

540


Which mysql function is used to concatenate string?

771


how can you test for null values in a database? : Mysql dba

472


How can you retrieve a particular number of records from a table?

497


What is 'mysqld'?

506


How do you kill a long running query in mysql?

464


How can you validate emails using a single query?

454


How big is a blob mysql?

497