|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: MIN
Definition: MIN(expression) OVER (analytic clause) Example Usage Aggregate: The below SQL retrieves the minimum salary in each job category from EMPLOYEE table. SELECT JOB_ID, MIN(SALARY) Analytic: The below SQL displays the most experienced employee in each job category. SELECT ENAME, JOB_ID, HIRE_DATE Related Links:
Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |