The use of LAST_VALUE() AND FIRST_VALUE() with an example



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

Post New Answer

More Database Management Interview Questions

What are the main functions of a database management system?

0 Answers  


What is database transaction?

0 Answers  


What is a table called in database?

0 Answers  


How to prevent concurrent access to my data?

0 Answers   HCL,


Define database lock?

0 Answers  






Which is the most used database?

0 Answers  


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.

1 Answers  


Explain the hierarchical database?

0 Answers  


what are the advantages of using them.

0 Answers  


Can we store images in database?

0 Answers  


What is different keys in dbms?

0 Answers  


what are the differences between an exclusive lock and a shared lock?

0 Answers  


Categories