oracle_培訓(xùn)_les05_chinese(參考版)
2024-10-06 16:51本頁面
【正文】 。 ? 在查詢中使用 GROUP BY 子句。 Oracle Corporation, 2022. All rights reserved. SELECT column, group_function(column) FROM table [WHERE condition] [GROUP BY group_by_expression] [HAVING group_condition] [ORDER BY column]。 Oracle Corporation, 2022. All rights reserved. 嵌套組函數(shù) 顯示平均工資的最大值 SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id。 GROUP BY job_id HAVING SUM(salary) 13000 ORDER BY SUM(salary)。 Oracle Corporation, 2022. All rights reserved. SELECT job_id, SUM(salary) PAYROLL FROM employees WHERE job_id NOT LIKE 39。 Oracle Corporation, 2022. All rights reserved. HAVING 子句 SELECT department_id, MAX(salary) FROM employees GROUP BY department_id HAVING MAX(salary)10000 。 3. 滿足 HAVING 子句中條件的分組將被顯示。 過濾分組： HAVING 子句 使用 HAVING 過濾分組 : 1. 行已經(jīng)被分組。 Oracle Corporation, 2022. All rights reserved. 過濾分組 The maximum salary per department when it is greater than $10,000 EMPLOYEES … 522 Copyright 169。 SELECT department_id, AVG(s
法律信息相關(guān)推薦
鄂ICP備17016276號-1