Is it possible to delete duplicate rows in a table without
using a temporary table ?
Answer Posted / ruban
Use ROWID function. It's available only sql server 2005 and
greater
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to backup SQL Server Reporting Services ?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is the difference between web edition and business edition?
What is difference between count (*) and count column?
How you can move data or databases between servers and databases in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
If user is owning any SQL Objects, can we drop that user
What is temporal data type?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Is it true, that there is no difference between a rule and a check constraint?
Differentiate between mongodb vs. Sql server?
What is sql server used for?
What are unicode character string data types in ms sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Differentiate sql server reporting services vs. Crystal reports?