What is window clause?
Answer / dinesh
window clause are used in analytic Function.
window clause are two type ROW and RANGE
| Is This Answer Correct ? | 2 Yes | 0 No |
discuss about myisam index statistics collection. : Sql dba
What are the types of index in sql?
Explain the working of foreign key?
What is sql engine in oracle?
how to retrieve only duplicate values in a table
What is the usage of distinct keyword?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How does stored procedure reduce network traffic?
what are the authentication modes in sql server? : Sql dba
how many groups of data types? : Sql dba
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
How to fetch the rows by dynamicaly passing table name through cursor?
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)