What is blocking and how would you troubleshoot it? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
what do you understand by change data capture?
How do I find the port number for sql server?
What are the different types of collation sensitivity in sql server?
What is equi join with example?
What is the order in which the sql query is executed?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How to provide values to user defined function parameters?
Define msdb database?
Is sql server is free?
what is the difference between table and view
Explain the truncate command? : SQL Server Architecture
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
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)