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 does <> mean in database?
What do you mean by deadlock dbms?
Explain the importance of database partitioning.
What does clipper stand for?
What is a RADIO GROUP ?
What are some of the important security features of a dbms?
What are the four objectives of the selection of a data type?
Name the two files that are created when you generate a form ?
What do you mean by aggregate and scalar functions in dbms?
Enlist some commands of dcl?
How is a database related to a table?
What is normalisation and its type?