Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
FIRST Function
ORDER BY Clause
GROUP BY Clause
FUNCTION: LAST
SELECT LAST(field) AS [expression]
FROM table
[WHERE ...]
[GROUP BY ...]
[ORDER BY ...]
The
LAST
function is used to return the value of the last record in the designated field Therefore, this function returns a single value. Since the records are returned in an arbitrary order, the last record will also be arbitrary. You can use the
ORDER BY
clause to order the records.
The companion
FIRST
function returns the first record in the designated field.
This code finds the last birthdate in a table of MediCare patients that is ordered by the age field.
SELECT LAST(birthdate) AS LastBirthDate
FROM MediCarePatients
ORDER BY age
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
