CODEWITHSUNDEEP
sql
xSea
xSea

Reputation: 212

Get first record by latest date

Please help complete this sql string? I want to get 1st record from table 1 where createddate = most recent/latest.

Select TOP 1 * From Table1 Where CreateDate = "latest date??"

Upvotes: 1

Views: 34

Answers (3)

J. Chomel
J. Chomel

Reputation: 8395

Or without TOP, using subquery:

Select * 
  From Table1 
 Where CreateDate = (select max(CreateDate) from Table1)
;

Upvotes: 1

Teddybugs
Teddybugs

Reputation: 1244

the other way to do it:

select * From Table1 order by CreateDate DESC Limit 1

Upvotes: 1

Jens
Jens

Reputation: 69440

use order by

Select TOP 1 * From Table1 order by createddate desc

Upvotes: 0

Related Questions