distinct <column name> from <table name>

how to delete duplicate rows in sql server 2005?

Question Posted / shashikant

Answer Posted / shashikant

distinct <column name>
from <table name>

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is the difference between gui testing and database testing? : Mysql dba

1155

What is pragma serially_reusable and why is it used?

899

What is row level locking in access?

931

How to show table structure mysql?

1055

How to drop an existing table in mysql?

1057

How do I create a new database in mysql?

955

What is pdo in mysql?

969

How many rows mysql can handle?

978

What is mysqlcheck do?

1082

Which is faster mongodb or mysql?

940

How to use count function in mysql?

965

What are date and time functions in mysql?

1061

Write a command with which mysql table can be repaired

986

What is a deterministic function?

1117

What is the difference between myisam dynamic and myisam static in mysql?

1051