Snippet Name: LAST Description: Returns the row ranked last using DENSE_RANK. Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_COUNT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAG Comment: Also see the page on 'FIRST'. Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: Returns the row ranked last using DENSE_RANK.
Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_COUNT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAG
<aggregate function> KEEP (DENSE_RANK LAST ORDER BY (<expression> <ASC | DESC> NULLS <FIRST | LAST>)