how are rank and dense rank being alloted for column with same values over a particular column
What is database white box testing and black box testing?
Which are the different types of indexes in sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Why partition by is used in sql?
How do I edit a stored procedure?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can you create a table with Primary Key not as the clustered index.
What is difference between cursor and ref cursor?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
What is recursive stored procedure?
how to retrieve the top 2 salaried persons from a database?
Do you understand the meaning of exception handling?
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)