Explain the properties of sub-query in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How to modify an existing user defined function?
What are acid properties of transaction?
Explain few examples of stored procedure over triggers?
What is the purpose of self join?
How to read 2nd highest sal from EMP table?
What is data modification?
what are database files and filegroups? : Sql server database administration
What are the different types of cursor?
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 function of ROLLUP ?
what are acid properties? : Sql server database administration
How to find related tables 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)