Snippet Name: MIN Description: Returns the minimum value by partition. 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 » MAX » LEAD » LAST_VALUE » LAST » LAG Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: Returns the minimum value by partition.
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 » MAX » LEAD » LAST_VALUE » LAST » LAG
MIN (<DISTINCT | ALL> expression) OVER (<analytic clause>) conn oe/oe SELECT manager_id, last_name, salary FROM ( SELECT manager_id, last_name, salary, MAX(salary) OVER (PARTITION BY manager_id) AS rmax_sal FROM employees) WHERE salary = rmax_sal;
