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
How big is a big database?
What is the type of image in database?
How do I keep my database up to date?
What is the structure of a database?
What is dba stand for?
Define database lock and its types.
How to open the database in exclusive mode?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
What do you understand by database triggers?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
Which is better saving files in database or in file system?
What do you understand by ‘database’?
What are functions in database?
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.
What is data model and types?