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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How big is a big database?

477


What is the type of image in database?

471


How do I keep my database up to date?

514


What is the structure of a database?

473


What is dba stand for?

483






Define database lock and its types.

510


How to open the database in exclusive mode?

468


Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

512


What do you understand by database triggers?

509


Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1488


Which is better saving files in database or in file system?

479


What do you understand by ‘database’?

549


What are functions in database?

517


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1477


What is data model and types?

527