SELECT EMPNAME,SAL FROM EMP GROUP BY EMPNAME,SAL

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 / jansi rani

14 Answers
22194 Views
I also Faced
E-Mail Answers

Answer Posted / jansi rani

SELECT EMPNAME,SAL FROM EMP GROUP BY EMPNAME,SAL

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1200

User wants only to display only pdf as export option in report manager. How to achieve this?

262

what changed between the previous version of sql server and the current version? : Sql server database administration

1000

what is create database syntax? : Sql server database administration

1104

Explain about system stored procedure?

1031

What are cursors in ms sql server?

1173

What are alternate keys?

976

What is extended stored procedures?

960

What are the advantages of user defined function?

980

Do you know what is bit data type and whats the information that can be stored inside a bit column?

955

How to create a view with data from multiple tables?

1010

How do I get to sql server configuration manager?

1009

Explain few examples of RDBMS?

1037

What is the difference between dbcc indexdefrag and dbcc reindex?

981

How to filter out duplications in the returning rows in ms sql server?

1132