oracle_培訓(xùn)_les17_chinese-wenkub.com
2024-10-02 16:57 本頁面
【正文】 ………1 2 3 4 1719 Copyright 169。 Oracle Corporation, 2022. All rights reserved. 復(fù)合列應(yīng)用舉例 SELECT department_id, job_id, manager_id, SUM(salary) FROM employees GROUP BY ROLLUP( department_id,(job_id, manager_id))。 1714 Copyright 169。 1712 Copyright 169。 1710 Copyright 169。 178 Copyright 169。 176 Copyright 169。 Oracle Corporation, 2022. All rights reserved. GROUP BY 子句 SELECT department_id, job_id, SUM(salary), COUNT(employee_id) FROM employees GROUP BY department_id, job_id 。 Oracle Corporation, 2022. All rights reserved. 組函數(shù) 組函數(shù)處理多行返回一個行 SELECT [column,] group_function(column). . . FROM table [WHERE condition] [GROUP BY group_by_expression] [ORDER BY column]。Copyright 169。 SELECT AVG(salary), STDDEV(salary), COUNT(mission_pct),MAX(hire_date) FROM employees WHERE job_id LIKE 39。 SELECT [column,] FROM table [WHERE condition] [GROUP BY group_by_expression] [ORDER BY column]。 Oracle Corporation, 2022.
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1