1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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

Question Posted / kumar


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 the purpose of queries in a database?

0 Answers  

How to know the Architecture of the Database

0 Answers   HCL,

Define atomicity and aggregation.

0 Answers  

What is file manager?

0 Answers  

What is system r? How many of its two major subsystems?

0 Answers  




What is the use of PARFILE option in EXP command ?

1 Answers  

What are the objectives of rdbms?

0 Answers  

Explain 4nf?

0 Answers  

what is the use of SYSTEM.EFFECTIVE.DATE varaible ?

1 Answers  

What is sql and where is it used?

0 Answers  

hi, i am new to database cau give me link where can i get about databse..

0 Answers  

Explain meant by 3-tier architecture?

0 Answers  

For more Database Management Interview Questions Click Here
Categories