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

Question Posted / kumar

1 Answers
5060 Views
Amazon, I also Faced
E-Mail Answers

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 is sql and where is it used?

0 Answers

What is the difference between horizontal and vertical partitioning?

0 Answers

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers

How many types of users in dbms?

0 Answers

What is the purpose of a model?

0 Answers

What are the advantages of dbms?

0 Answers

What is database management used for?

0 Answers

State at least four kinds of indexing?

0 Answers Amazon, iNautix,

What are the package used in DBMS ?