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
- 14 Answers
- 22932 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
What are wait types?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Does view occupy space?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between for xml raw and for xml auto?
Why should you use or avoid select * statements?
How can you append an identity column to a temporary table?
How efficient you are in oracle and SQL server?
Can sql servers link to other servers like oracle?
What are different types of constraints?
Why use identity in sql server?
Explain system functions or built-in functions? What are different types of system functions?
Equi join and non equi join is possible with sql server?
Disadvantages of the indexes?
what is spatial nonclustered index
