How to delete duplicate rows?

Question Posted / gulshan prasd

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What is difference between stored procedure and user defined function?

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

What is the difference between a primary key and a unique key? Are they the same?

Explain isolation levels that sql server supports?

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

How to create a ddl trigger using "create trigger" statements?

How retrieve field names from the table in SQL through JAVA code?

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

How can change procedure in sql server?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

How can you control the amount of free space in your index pages?

How to delete database objects with "drop" statements in ms sql server?

For more SQL Server Interview Questions Click Here