How you can find out if an index is useful to the optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
List some advantages and disadvantages of stored procedure?
What are the steps you can take to avoid “deadlocks”?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is the bookmark lookup and rid lookup?
what is difference between primary key and Unique
what is procedure in sql?
Define constraints and give an example of their use?
How to download microsoft sql server 2005 express edition?
What are the different types of collation sensitivity?
how many instance use in sql server 2005
What is db stored procedure?
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)