Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records from the table?(Table must have
unique id)
- 7 Answers
- 12092 Views
- TCS, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / lince
DELETE
FROM MyTable
WHERE ID IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1 HAVING COUNT(ID)>1
)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is database isolation in sql server? : sql server database administration
Explain the difference between control flow and data flow?
What is optimization and its types?
what are the reporting service components in SSRS?
What is shrink log file?
What is system stored procedures?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What are locks in sql?
How do I create a stored procedure in dbml?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Mention the uses of stored procedures.
What is the difference between indexing and hashing?
What is the federation in sql azure?
What is the Control Flow in SSIS
List out some of the requirements to set up a sql server failover cluster?
