Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 32666 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / lince thomas
it is very simple,,below
------------------------
select * from(
select row_number() over(partition by empname order by
empname)as rno,empname,salary from Emp1Pay)T
where T.rno>1
delete from Emp1Pay where empid=
(select empid from(select row_number() over(partition by
empname order by empname)as rno,empid
from Emp1Pay )T where T.rno>1)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
Explain external key management in sql server 2008
Which language is supported by sql server?
What is store procedure? When do you use?
How to convert a numeric expression from one data type to another?
What is a transact-sql statement?
what is memory-optimized nonclustered indexes
Explain the difference between functions and stored procedures in sql server?
What are the underflow and overflow behaviors on float literals?
What are the requirements on sql server network connections?
What is the function of sql server agent windows service?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Is resultset an interface?
What are page splits? : SQL Server Architecture
What is the difference between Normalization and De-normalization?
