Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 75304 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / subrata paul
Delete TOP(1)from example where[ID]=1
| Is This Answer Correct ? | 4 Yes | 10 No |
Post New Answer View All Answers
A trigger can reference objects outside the current database? State true or false.
Explain the steps to create and execute a user-defined function in the sql server?
Explain multiserver query
how to define testing of network layers? : Sql server database administration
What is sql server query analyzer?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain the etl (extraction, transformation, and loading)?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is equi join with example?
How to check if stored procedure is running in sql server?
Give an example of SQL injection attack ?
Can we do dml on views?
What samples and sample databases are provided by microsoft?
What is tempdb in sql server?
