write a query to remove duplicate records without using primary key column?
- 2 Answers
- 8479 Views
- ABCO, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mathanrathinam
delete tmp from(select col1,col2,row_number over(partition by col1,col2 order by col1,col2) rownum from tablename) tmp
where rownum >1
| Is This Answer Correct ? | 7 Yes | 8 No |
List out different types of normalizations in sql server and explain each of them?
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
What are sql server procedures?
What are sp_configure commands and set commands?
What is molap and its advantage? : sql server analysis services, ssas
How to read 2nd highest sal from EMP table?
What is meant by dirty read?
Is index a datbase objects in sql server?
What is the purpose of forms?
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Different Types of Functions ?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
