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

How many rows we can insert in a mysql table?

963

What is data types in mysql?

923

How to run a sql statement?

1033

How to create table show example

975

How large can a mysql table be?

958

Can mysql and mariadb coexist?

1092

What is the limit of mysql database?

958

How you will show all data from a table.

988

How can we convert between Unix & MySQL timestamps?

967

What is mysql server used for?

958

What is mysql shell?

985

What is a crosstab query?

960

What is the usage of regular expressions in mysql?

902

How do you create a new database in mysql?

915

What is mysqlcommand?

1001