Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is Normalization and its different forms?

1099


List few ways to code transactions in an efficient manner?

962


dear sir please provide what question will be asked in bank it officer interview

2178


What are the features of openedge features?

1081


I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

2227


Is google a database?

1260


What is the license for clipper?

997


What is domain in dbms?

1015


What is system catalog or catalog relation?

1140


What are the differences between a dbms and rdbms?

1062


Explain top-n analysis in DBMS.

1655


What are different cursor types in dbms?

1115


What is the use case where we can use stretch database?

987


What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

908


How do you use a database worksheet?

984