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 |
write a query to delete similar records in particular fields(columns) in different tables
what is table? : Sql dba
what is the different between now() and current_date()? : Sql dba
In what condition is it good to disable a trigger?
What is the usage of nvl function?
What are sql commands?
which types of join is used in sql widely? : Sql dba
What is the use of partition by in sql?
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
Is nosql relational?
how to convert character strings to numeric values? : Sql dba
How do I quit sql?
Oracle (3253)
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)