How to delete duplicate rows in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we need normalization?
Explain encryption of entire databases without the need for application changes in sql server 2008?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What is difference between view and materialized view?
Differences between functions and stored procedures?
8 Answers 247Customer, Accenture,
What is a job?
why would you call update statistics? : Sql server database administration
How to run sql server 2005 books online on your local system?
what is IDE,DMV in sql server?
How to convert numeric expression data types using the cast() function?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How to get all stored procedures in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)