Is it possible to delete duplicate rows in a table without
using a temporary table ?
Answer Posted / ghous
using cursor is another option
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is report server project?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is sql profiler. What are the default templates with it? : sql server database administration
What is the optimization being performed in oracle and SQL Server?
Is a primary key unique?
What are the different types of locks in the database?
How do you run a trace?
Why use “pivot” in sql server?
what is an index? : Sql server database administration
What is the significance of master, tempdb and model databases?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
what are the reporting service components in SSRS?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Write an SQL query to obtain the 2nd highest salary.
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?