Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can Multiple Columns Be Used in GROUP BY
Can Multiple Columns Be Used in GROUP BY? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department:
SQL> SELECT department_id, salary, count(*) 2 FROM employees GROUP BY department_id, 3 salary HAVING count(*) > 1; DEPARTMENT_ID SALARY COUNT(*) ------------- ---------- ---------- 90 17000 2 50 3200 4 50 2200 2 50 3600 2 80 10500 2 80 9000 2 50 2700 2 ......
2007-04-20, 4832👍, 0💬
Popular Posts:
How To Get the Minimum or Maximum Value of an Array? - PHP Script Tips - PHP Built-in Functions for ...
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
What’s the difference between Unit testing, Assembly testing and Regression testing? Unit testing is...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...