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 |
How many types of indexes are there in sql?
What is substitution variable?
How many types of index are there?
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
what is blob? : Sql dba
Why do we use sql constraints?
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
What is integrity constraints?
What are tables and fields in the database?
Why should I use postgresql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What are records give examples?
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)