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

select * from (
    select bla
    from bla
    where bla
    order by finaldate desc
)
where rownum < 2

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to sql-order-by

• Laravel Eloquent: Ordering results of all() • SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12 • SQL ORDER BY multiple columns • How to use Oracle ORDER BY and ROWNUM correctly? • MySQL order by before group by • Ordering by specific field value first • MySQL ORDER BY multiple column ASC and DESC • How can I get just the first row in a result set AFTER ordering? • SQL order string as number • Order by multiple columns with Doctrine