Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 33018 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / arun kumar k s
drop table #TEMP select distinct * into #TEMP from
TABLE_NAME delete from TABLE_NAME insert into TABLE_NAME
select * from #TEMP
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are points to remember while using the fillfactor argument?
Explain rdbms?
Explain candidate key, alternate key, and composite key?
Can we perform backup restore operation on tempdb? : sql server database administration
How to loop through result set objects using mssql_fetch_array()?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What are commonly used odbc functions in php?
What are different types of views?
What do you mean by a dependent functionality in a build?
What is 2nf normalization?
Explain “not null constraint” in sql server?
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 ...
How to concatenate two binary strings together?
What is a partitioned view?
State the difference between local and global temporary tables?
