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

Question Posted / kumar

1 Answers
4964 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

Why do I need netlib?

0 Answers

What are the functions of database management system?

0 Answers

Can we save image in database?

0 Answers

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers

what are the acid properties in dbms?

0 Answers

What are its two major subsystems of r?

0 Answers

Name two utilities that oracle provides, which are use for backup and recovery.

0 Answers

What do you understand by data independence?

0 Answers

What are the disadvantages of file processing systems?

0 Answers

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?