How do I do top 1 in Oracle? [duplicate]

by

If you want just a first selected row, you can:

select fname from MyTbl where rownum = 1

You can also use analytic functions to order and take the top x:

select max(fname) over (rank() order by some_factor) from MyTbl

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 limit the number of rows returned by an Oracle query after ordering?
  3. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  4. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  5. How can I select from list of values in Oracle
  6. PLS-00428: an INTO clause is expected in this SELECT statement
  7. Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate]
  8. How to get the last row of an Oracle table
  9. Using pivot on multiple columns of an Oracle row
  10. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  11. Pivoting of data using two columns
  12. INSERT SELECT statement in Oracle 11G
  13. Sleep function in ORACLE
  14. SQL Error: ORA-00942 table or view does not exist
  15. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  16. Nth max salary in Oracle
  17. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  18. Display names of all constraints for a table in Oracle SQL
  19. Autoincrement in oracle to already created table
  20. Oracle 11g – Check constraint with RegEx
  21. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  22. How to use a dynamic parameter in a IN clause of a JPA named query?
  23. Why does the wm_concat not work here?
  24. The network adapter could not establish the connection – Oracle 11g
  25. Oracle string aggregation
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. How to call Oracle MD5 hash function?
  28. Oracle RAC and sequences
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. Insert into from CTE

Leave a Comment