Can we write trigger for view?
No Answer is Posted For this Question
Be the First to Post Answer
Name few of the dcl commands in sql?
What are the advantages of mirroring?
What is de-normalization in sql database administration? Give examples?
How do you create type- insensitive operator?
How to restore performance issues and how to check?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is row_number()?
what is Full Text Search ?
What are magic tables in sql server?
How to create a simple table to test triggers in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
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)