日期:2014-05-16  浏览次数:20905 次

Multiple-row functions和Single-row functions有什么区别
求高手各举个例子说明

------解决方案--------------------
单行函数:
每一行都有一个结果
SQL> SELECT last_name,TRUNC((SYSDATE-hire_date)/7,0) AS weeks
2 FROM employees
3 WHERE department_id = 90;

LAST_NAME WEEKS
-------------------------------------------------- ----------
King 1267
Kochhar 1148
De Haan 976

多行函数只有一个结果
SQL> SELECT count(distinct salary) FROM employees ;

COUNT(DISTINCTSALARY)
---------------------
57