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

What is difference between materialized view and view?

953

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1984

Explain nested trigger in sql?

1130

What is join and name different type of joins?

1097

What is sharding?

116

New concepts of sql server 2005 use in your project.

2401

What is clustered primary key?

1082

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

158

What is meant by Active-Passive and Active-Active clustering setup?

1272

What are the types of subscriptions in SQL Server replication?

1104

Do you know what are the reporting services components?

1020

What is the filtered index?

1110

What happens when converting big values to numeric data types?

1226

What is a full text index?

965

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1113