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 mysql used for?

907

How do I setup mysql?

853

How do you shutdown a mysql database?

981

What is the datatype of image in mysql?

868

What is mysql optimization?

857

Is sql similar to mysql?

820

How can you take the backup and restore a mysql database using php?

906

What is difference between oracle and mysql?

886

How we can create index in mysql?

921

How can you add and remove any column of a table?

880

What is mysql database used for?

956

What are the similarities between a function and a procedure?

825

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4593

What is a simple query?

843

How do I rename a table in mysql workbench?

904