Receive all updates via Facebook. Just Click the Like Button Below

Blogger Widgets
/

Watch Intro About My Website ! ! !

Wednesday, 6 November 2013


The LAST() function returns the last value of the selected column.

SQL LAST() Syntax

SELECT LAST(column_name) FROM table_name

SQL LAST() Example


We have the following "Orders" table:

Id
OrderDate
OrderPrice
Customer
1
2008/11/12
1000
Navis
2
2008/10/23
1600
Nilsen
3
2008/09/02
700
Navis
4
2008/09/03
300
Navis
5
2008/08/30
2000
Jensen
6
2008/10/04
100
Nilsen

Now we want to find the last value of the "OrderPrice" column.

We use the following SQL statement:

SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders
 

SELECT OrderPrice FROM Orders ORDER BY Id DESC LIMIT 1

The result-set will look like this:

LastOrderPrice
100

Tagged:

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...