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

State some commands of ddl in dbms?

1020

Explain the concepts of a primary key and foreign key.

883

Explain environment of openedge?

945

What is e-r model in the dbms?

1058

What are the disadvantage in file processing system?

982

How to pump the data from one database to another?

923

What are collection pools? What are the advantages?

894

What is the advantages and disadvantages of database management system?

1021

What entity means?

866

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

1008

What is partial key?

1057

Define cursor.

1032

What is optimization in database?

934

What is table normalization?

933

In DBMS, what are the two integrity rules used?

944