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...

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

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

Question Posted / kivi

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 dbms and types of dbms?

999

what is the difference between filters and conditions?

2355

Define scalar functions.

932

Is there an example how to configure udfaccess setting in firebird.conf?

912

How do you open .db files?

849

What are the main functions of a database management system?

892

What is the structure of a table in database?

927

What is the purpose of a database?

992

What is 1nf in the dbms?

944

Explain the terms ‘attribute’ and ‘relations’

1093

What are the limitations of database?

839

When does checkpoint occur?

850

Define transaction and transaction isolation levels?

938

Explain the importance of database partitioning.

899

Explain the difference between primary and foreign key?

946