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 Normalization and its different forms?
List few ways to code transactions in an efficient manner?
dear sir please provide what question will be asked in bank it officer interview
What are the features of openedge features?
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
Is google a database?
What is the license for clipper?
What is domain in dbms?
What is system catalog or catalog relation?
What are the differences between a dbms and rdbms?
Explain top-n analysis in DBMS.
What are different cursor types in dbms?
What is the use case where we can use stretch database?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
How do you use a database worksheet?