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 |
Define join and enlist its types.
What is the easiest database to learn?
Mention a query to add email validation to your database
What is the use of drop command and what are the differences between drop, truncate and delete commands?
Explain a join between tables?
What is data modelling techniques?
What are database modules?
What is a table called in database?
What is super key in dbms?
What does a COMMIT statement do to a CURSOR?
Which parameters are optional in init.ora parameter file?
Explain the functionality of dml compiler.