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 are the main functions of a database management system?
What is database transaction?
What is a table called in database?
How to prevent concurrent access to my data?
Define database lock?
Which is the most used database?
Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.
Explain the hierarchical database?
what are the advantages of using them.
Can we store images in database?
What is different keys in dbms?
what are the differences between an exclusive lock and a shared lock?