Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13436 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / surendra pal singh
delete from tablename where empname in (select empname from table name group by empname having empid>1)
where empname and empid are the columns of the table.
definately it will work
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalization according to you and explain its different levels?
What is a View ? Can we insert, Update and delete a view?
What language is sql server written in?
What are date and time data types in ms sql server?
Why I am getting this error when dropping a database in ms sql server?
What do you understand by replication in sql server?
What are the system database in sql server 2008?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Mention what are the core components of ssrs?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Explain steps of normalization?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
If the job running very slow what is the action you do
How to create user messages with print statements in ms sql server?
What is filestream?
