how to delete duplicate rows from table in sql server
Answers were Sorted based on User's Feedback
Answer / suresh s
delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)
| Is This Answer Correct ? | 25 Yes | 30 No |
Answer / swapna
We can delete duplicate rows from table by using distinct
command.
| Is This Answer Correct ? | 10 Yes | 35 No |
Is candidate a key?
What is collation sensitivity? Explain different types.
What is the process of normalising?
How to download and install sql server 2005 books online?
explain the type of contraints
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,
What is the distinction amongst delete and truncate?
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
Do you know how to send email from database?
What is a domain constraint give an example?
What is the difference between UNION and UNIONALL?
5 Answers CarrizalSoft Technologies, CTS,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)