Sign Up Login


  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 difference between foreign key and reference key

1 Answers  

Can the SNAPSHOTS be refreshed automatically ?

1 Answers  

How do you set up a database?

0 Answers  

What are the differences between drop, truncate and delete commands?

0 Answers  

What is indexing in database with example?

0 Answers  

Explain the different types of constraints in dbms?

0 Answers  

Can A column defined as PRIMARY KEY can have NULL values ?

2 Answers  

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

0 Answers  

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

0 Answers  

What is a database in layman terms?

0 Answers  

What do you understand by b-trees?

0 Answers  

What is database partition key?

0 Answers  

For more Database Management Interview Questions Click Here
Categories