Get top results for each group (in Oracle)

by

I don’t have an oracle instance handy right now so I have not tested this:

select *
from (select emp_id, name, occupation,
      rank() over ( partition by occupation order by emp_id) rank
      from employee)
where rank <= 3

Here is a link on how rank works: http://www.psoug.org/reference/rank.html

More Related Contents:

  1. GROUP BY with MAX(DATE) [duplicate]
  2. Return row with the max value of one column per group [duplicate]
  3. Fetch the row which has the Max value for a column
  4. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  5. Fetch the rows which have the Max value for a column for each distinct value of another column
  6. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  7. Select latest row for each group from oracle
  8. Nested SQL statements for Oracle [closed]
  9. Why do we combine several select statements
  10. Is there a combination of “LIKE” and “IN” in SQL?
  11. How ROWNUM works in pagination query?
  12. Get value based on max of a different column grouped by another column [duplicate]
  13. how do I query sql for a latest record date for each user
  14. How to declare variable and use it in the same Oracle SQL script?
  15. Are a CASE statement and a DECODE equivalent?
  16. SQL recursive query on self referencing table (Oracle)
  17. PLS-00428: an INTO clause is expected in this SELECT statement
  18. Why use a JOIN clause versus a WHERE condition?
  19. format interval with to_char
  20. Oracle “Partition By” Keyword
  21. Array in IN() clause oracle PLSQL
  22. Optimize groupwise maximum query
  23. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  24. calculate hours based on business hours in Oracle SQL
  25. Why does the wm_concat not work here?
  26. Return number from Oracle Select statement after parsing date
  27. How do you interpret a query’s explain plan?
  28. How to call Oracle MD5 hash function?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment