How to get the last row of an Oracle table

by

There is no such thing as the “last” row in a table, as an Oracle table has no concept of order.

However, assuming that you wanted to find the last inserted primary key and that this primary key is an incrementing number, you could do something like this:

select *
  from ( select a.*, max(pk) over () as max_pk
           from my_table a
                )
 where pk = max_pk

If you have the date that each row was created this would become, if the column is named created:

select *
  from ( select a.*, max(created) over () as max_created
           from my_table a
                )
 where created = max_created

Alternatively, you can use an aggregate query, for example:

select *
  from my_table
 where pk = ( select max(pk) from my_table )

Here’s a little SQL Fiddle to demonstrate.

More Related Contents:

  1. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  2. How do I do top 1 in Oracle? [duplicate]
  3. REGEX to select nth value from a list, allowing for nulls
  4. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  5. How can I select from list of values in Oracle
  6. PLS-00428: an INTO clause is expected in this SELECT statement
  7. Using pivot on multiple columns of an Oracle row
  8. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  9. Pivoting of data using two columns
  10. INSERT SELECT statement in Oracle 11G
  11. Sleep function in ORACLE
  12. SQL Error: ORA-00942 table or view does not exist
  13. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  14. Nth max salary in Oracle
  15. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  16. Display names of all constraints for a table in Oracle SQL
  17. Autoincrement in oracle to already created table
  18. Oracle 11g – Check constraint with RegEx
  19. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  20. How to use a dynamic parameter in a IN clause of a JPA named query?
  21. Why does the wm_concat not work here?
  22. The network adapter could not establish the connection – Oracle 11g
  23. Oracle string aggregation
  24. Curious issue with Oracle UNION and ORDER BY
  25. Subtracting Dates in Oracle – Number or Interval Datatype?
  26. How to call Oracle MD5 hash function?
  27. Oracle RAC and sequences
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Insert into from CTE
  30. Fetch the rows which have the Max value for a column for each distinct value of another column

Leave a Comment