select distinct * from tablename

Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500

Output should be

A 200
B 300
C 400
D 500

Question Posted / navneet sharma

14 Answers
21704 Views
I also Faced
E-Mail Answers

Answer Posted / navneet sharma

select distinct * from tablename

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What information is maintained within the msdb database?

925

How can we use ConnectorJ JDBC Driver with MS SQL?

950

What is the difference between Stored Procedures and triggers?

1034

Explain powershell included in sql server 2008?

999

what's the maximum size of a row? : Sql server database administration

1013

Why we use functions in sql server?

1011

What happens when converting big values to numeric data types?

1029

what are the new features introduced in sql server 2000? : Sql server database administration

871

Explain data warehousing in sql server?

988

What is mean by dml?

945

What is a transact-sql statement?

980

what is a sub-report?

132

What is measure group, measure? : sql server analysis services, ssas

960

In what sequence sql statement is processed?

953

What is the difference between ddl and dml?

1003