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 |
What are the characteristics of data in the database?
What is ddl in dbms?
What is dbms and types of dbms?
5) Which acid property will effect when we use commit in trigger?
Explain vdl (view definition language)?
What is mean by dbms?
What are the importance of partitioning in dbms?
Is facebook a database?
What are the characteristics of dbms?
Enlist some commands of ddl?
What is the purpose of a database?
How is the pattern matching done in the sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)