SELECT DISTINCT * INTO Employee1 FROM Employee DROP Table Employee sp

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 / gaurav sharma

14 Answers
22256 Views
I also Faced
E-Mail Answers

Answer Posted / gaurav sharma

SELECT DISTINCT * INTO Employee1 FROM Employee
DROP Table Employee
sp_rename 'Employee1','Employee'

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is order of B+tree?

1107

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2077

what is the different types of backups available in sql server? : Sql server database administration

931

Explain data warehousing in sql server?

1051

Explain iaas, paas and saas?

What is Federation and Federation Member?

How do you send email on SQL Server?

1065

Does full backup break log chain?

963

Define normalisation?

1118

How to move database physical files in ms sql server?

1033

What is the default port for SQL Server over a firewall?

1099

How to restore performance issues and how to check?

2004

What are the different Topologies in which Replication can be configured?

1185

Explain few of the new features of sql server 2008 management studio

922

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

941