How can I get just the first row in a result set AFTER ordering

Question

This gives me just one row  the first one    SELECT BLA FROM BLA WHERE BLA AND ROWNUM  lt  2   However  I want the most recent date val  I can make that the first row this way   SELECT BLA FROM BLA WHERE BLA ORDER BY FINALDATE DESC   When I try to mix the two partial victories  though  it doesn t work - apparently the  Select the first row only  logic fires before the order by  and then the order by is subsequently ignored

User · Accepted Answer

This question is similar to How do I limit the number of rows returned by an Oracle query after ordering?.

It talks about how to implement a MySQL limit on an oracle database which judging by your tags and post is what you are using.

The relevant section is:

select *
from  
  ( select * 
  from emp 
  order by sal desc ) 
  where ROWNUM <= 5;

User · Answer

In 12c  here s the new way   select bla   from bla  where bla  order by finaldate desc  fetch first 1 rows only     How nice is that

User · Answer

An alternative way   SELECT     FROM bla WHERE finalDate    SELECT MAX finalDate  FROM bla  AND       rownum   1

User · Answer

You can nest your queries   select   from       select bla     from bla     where bla     order by finaldate desc   where rownum  lt  2

[sql] How can I get just the first row in a result set AFTER ordering?

Examples related to sql

Examples related to oracle

Examples related to sql-order-by