The use of LAST_VALUE() AND FIRST_VALUE() with an example
Answer / kivi
they are the analytic functions used get the first and last value from a group..
check the below link for more details
http://etltechsolutions.wordpress.com/2014/10/12/last_value-and-first_value-best-example/
| Is This Answer Correct ? | 0 Yes | 0 No |
Is mysql a rdbms?
Which two can be implemented as a centrally located logical architecture?
Explain degree of a relation?
Explain concurrency transparency.
What is a field in database?
What are the components of a database management system?
Define union all operator and union.
What is cold backup and hot backup (in case of oracle)?
Enlist some commands of ddl, dml, and dcl.
Is google a database?
What are the elements of a database?
What are the ways to tune reporting services?
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)