choose record which have max value of createdDateTime ax2012

Question

I'm writing a select statement,

I want to choose record which createdDateTime value is nearest.

For example

I want to choose second line, because it has max value.

How can i add this condition in my select statement?

Answer 1

Please check the example below:

Table   table;
;

select firstOnly table
    order by table.createdDateTime desc;

Select Statement Syntax