The use of LAST_VALUE() AND FIRST_VALUE() with an example
Answer Posted / 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 |
Post New Answer View All Answers
What is a relation schema?
What is hashing in dbms?
What are the functions of database management system?
Mention the differences between trigger and stored procedures
What is normalization in database with example?
What is a hierarchical database?
What is the purpose of using a model?
What is dbms function?
What database does facebook use?
What is sql rdbms?
Write about Transaction Management in Oracle 9i?
What is computer end?
How to monitor firebird server activity?
What is database url?
What are the benefits of database management system?