How to get last record in query

The best way if you are using MS SQL is;

Select MAX(bulletin_id) as LastRecord
From (your tablename)

select somefields
from sometables
where somefile = (select max(somefield)
from sometable)
etc

SELECT MAX(primary_key_field) AS MaxID
FROM some_table

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com


"PopcornCoder" <webforumsuser@macromedia.com> wrote in message
news:gcd9rq$8t3$1@forums.macromedia.com...
> What's the proper SQL syntax to get the last record in a table.

If bulletin_id is an autonumber column, then you can sort it by bulletin_id desc and limit 1. That will give you the row with the highest bulletin_id.

select * from foo_table
order by bulletin_id desc limit 1

I am going to sort it based on bulletin_id which is an auto numbering column and I want to get another column called bulletin_number.

-- duplicate post

Depends on the contents of the table.