SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 328 Page Views: 

Do you think that it is compulsory to delete duplicate rows in a table with the help of temporary table only?



Posted By: Avi Date: 1 October 2010 11:47:07 AM
 Answer:

No,Temporary table is not compulsory.It can be deleted without craeting temporary table by using ROWID function.


Posted By: avibtech

Date: 1 October 2010 11:47:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image GRaEFk
Related Questions
SQL Server : What is the basic concept of Serialization?

What is the basic concept of Serialization?

Serialization is the highest level of isolation. When Serialization is implemented then there will b....
Category: SQL Server Date: 10/1/2010 11:43:07 AM
SQL Server : Write the query to Select the name of the product whose total sales is 20 form the following table named sales:- PID Pname Sale 1 Soap 5 2 Brush 10 3 Tea 8 1 Soap 12 2 Brush 5

Write the query to Select the name of the product whose total sales is 20 form the following table n....

select Pname from sales group by PID having sum(sale)=130
Category: SQL Server Date: 10/1/2010 11:42:07 AM
SQL Server : What will be returned with @@identity T-Sql?

What will be returned with @@identity T-Sql?

It will return the last inserted identity value. It will return a numeric value. So whenever a row ....
Category: SQL Server Date: 10/1/2010 11:41:07 AM
SQL Server : Why there is a need to use secondary database file when the same work can be done with primary databse files?

Why there is a need to use secondary database file when the same work can be done with primary datab....

Secondary files can be spread over multiple disks which will enhance the I/O operations.
Category: SQL Server Date: 10/1/2010 11:40:07 AM
SQL Server : What will be the result of the following query ? Explain your answer. create table tempo (sno INT, item_code nvarchar(2)) ; insert into tempo select 1, '0' UNION select 2, '11' UNION select 3, '12' UNION select 4,'0' UNION select 5,'0' update t

What will be the result of the following query ? Explain your answer. create table tempo (sno INT,....

The given query will result inot 3 rows. Sno item_code 1 4 5 ....
Category: SQL Server Date: 10/1/2010 11:38:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories