Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76551 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / rajkamal
delete form emp
where (select distinct(ename)from emp)
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
What are the steps you should follow to start sql server in single-user mode?
explain different types of joins? : Sql server database administration
Why do you want to join software field as you have done your BE in Electronics?
How to connect php with different port numbers?
how you can deploy an ssrs report?
How to test values returned by a subquery with the in operator?
What are the approximate numeric data types?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Can you always create a cache of a report?
List out some of the requirements to set up a sql server failover cluster?
How to delete duplicate rows in sql server?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the difference between indexing and hashing?
Give the query of getting last two records from the table in SQL SERVER?
What is the default schema of your login session in ms sql server?
