Timeline for Select most recent inspection
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 27, 2017 at 1:40 | comment | added | User1974 |
Fair point. ypercube's answer here might be of interest, although he figures it's not much of an improvement on row_number .
|
|
| Oct 25, 2017 at 14:52 | comment | added | MT0 | @Wilson No - that will just fetch a certain number of rows from the entire result set - not a certain number of rows for each partition of the result set. | |
| Oct 25, 2017 at 14:38 | comment | added | User1974 |
Would Oracle 12c's FETCH FIRST functionality be a third option?
|
|
| Oct 21, 2017 at 21:09 | comment | added | MT0 |
@Wilson Yes, if you try putting the ROW_NUMBER() expression into the WHERE clause you will get ORA-30483: window functions are not allowed here.
|
|
| Oct 21, 2017 at 17:03 | comment | added | User1974 |
Why is it necessary for the WHERE clause to be in a subselect?
|
|
| Mar 1, 2017 at 17:25 | vote | accept | User1974 | ||
| Mar 1, 2017 at 15:31 | review | First posts | |||
| Mar 1, 2017 at 21:23 | |||||
| Mar 1, 2017 at 15:28 | history | edited | MT0 | CC BY-SA 3.0 |
added 13 characters in body
|
| Mar 1, 2017 at 15:22 | history | answered | MT0 | CC BY-SA 3.0 |