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
22665 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

Can group by and orderby be used together?

1069

how you can configure a running aggregate in SSRS?

199

What is sql server query analyzer?

1098

What is a periodical index?

975

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1003

Explain Normalization and DE normalization

1160

What is a data source or ds? : sql server analysis services, ssas

1051

What is an active database?

1067

Which sql server table is used to hold the stored procedure script?

1004

What languages bi uses to achieve the goal?

1050

What is 2nf normalization?

1088

How do I find the sql server version?

1080

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1062

Explain tables in SQL Azure?

122

What is sql server agent and what are the two modes of authentication in sql server?

1110