Write a query to delete duplicate records in SQL SERVER
Answer Posted / anuj
You have Two option You can use keyword Distinct or Group By Both will help you to delete dublicate records
Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
what are defaults? : Sql server database administration
How to defragment table indexes?
How to enter binary string literals in ms sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the system database in sql server 2008?
Explain what is use of dbcc commands?
how to define testing of network layers? : Sql server database administration
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is buffer cash in sql server?
Define a cross join?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is database isolation in sql server? : sql server database administration
What is a synonym for manipulation?
What is a transact-sql statement batch in ms sql server?
What is collation sensitivity?