how to delete duplicate rows in sql server 2005?

Question Posted / monty

2 Answers
5349 Views
EWIT, Reliance, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to delete duplicate rows in sql server 2005?..

Answer / shashikant

distinct <column name>
from <table name>

Is This Answer Correct ?

3 Yes

2 No

how to delete duplicate rows in sql server 2005?..

Answer / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Is This Answer Correct ?

1 Yes

9 No

Post New Answer

More MySQL Interview Questions

What is datadir?

0 Answers

Is mysql free download?

0 Answers

What are the features of Stored Procedures in MYSQL?

1 Answers

What is a deterministic function?

0 Answers

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers

How do you connect MySQL database with PHP?

0 Answers

What is the difference between the primary and unique key in mysql?

0 Answers

What is pdo mysql?

0 Answers

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers

What is delimiter in mysql stored procedure?

0 Answers

What is the use of mysql_close()?

0 Answers

How does mysql store data?

0 Answers

For more MySQL Interview Questions Click Here