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 |
What is netlib for clipper?
What is join? Mention its types.
Which of the packaged procedure is UNRESTRICTED ?
What is e-r model in the dbms?
Where is data stored in a database?
In DBMS, what are the two integrity rules used?
Why is data modelling important?
What are different partitioning techniques in database?
What is super key in dbms?
What is inner join in database?
What is a deadlock and mention how it can be resolved?
What is database management system with example?
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)