Analytical Function

WE using Last_value()analytical function but the result do not match according to me?

Questions by ashish88   answers by ashish88

Showing Answers 1 - 2 of 2 Answers

Avashisth

  • Feb 20th, 2010
 

Analytical function are the builtin function in Oracle, so during execution it will be faster then other simple function. These function are basically used for reporting and most of the time to improve performance of your query. Oracle have lot of analytical functions for eg.: rollup, rank, dense_rank etc.

  Was this answer useful?  Yes

Raj_P

  • Sep 1st, 2010
 

I am working on Oracle 9i and as far as I know the function "Last_Value" doesnt work in 9i. We are using the "First_Value" function with order by clause using descending order.

Select First_Value(FieldName) Over (Partition by FieldName Order by TrandDate Desc) From <TableName>.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions