Simple SQL query

Question

I have a table, with these columns:

ID  |  Data

How to find out which record has highest ID?

FrustratedWithFormsDesigner · Accepted Answer · 2010-10-25 19:18:04Z

9

To get the largest ID:

select max(ID) from myTable

To get a record that has the largest ID:

select *
from MyTable
where ID = (Select max(ID) from myTable)

answered Oct 25, 2010 at 19:18

27.7k31 gold badges151 silver badges211 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Stefanelli · Accepted Answer · 2010-10-25 19:19:22Z

2

select *
    from YourTable
    where ID = (select max(ID) from YourTable)

answered Oct 25, 2010 at 19:19

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Jamie Treworgy · Accepted Answer · 2010-10-25 19:25:54Z

2

select max(ID) from tablename

answered Oct 25, 2010 at 19:17

Jamie Treworgy

24.4k9 gold badges81 silver badges120 bronze badges

gbn · Accepted Answer · 2010-10-25 19:32:48Z

1

As well as max, you can use TOP on SQL Server

select TOP 1 * from myTable order by id desc

For joint top

select TOP 1 WITH TIES * from myTable order by id desc

Other engines have LIMIT not TOP. This can give the whol record without a separate MAX sub-query too

answered Oct 25, 2010 at 19:32

gbn

434k84 gold badges602 silver badges690 bronze badges