|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: |
-- Create table for testing
CREATE TABLE T1
(
KEY VARCHAR2(10 CHAR),
VAL INTEGER
);
Table created.
-- Add some test data
INSERT INTO T1 (KEY, VAL) VALUES ('A', 10);
1 row created.
INSERT INTO T1 (KEY, VAL) VALUES ('A', 20);
1 row created.
INSERT INTO T1 (KEY, VAL) VALUES ('B', 30);
1 row created.
INSERT INTO T1 (KEY, VAL) VALUES ('B', 40);
1 row created.
COMMIT;
Commit complete.
-- Display all data in table
SELECT * FROM T1;
KEY VAL
---------- ----------
A 10
A 20
B 30
B 40
4 rows selected.
-- Display sums of VAL by KEY
SELECT KEY, SUM(VAL) FROM T1 GROUP BY KEY;
KEY SUM(VAL)
---------- ----------
A 30
B 70
-- Try to find KEY with smallest SUM
SELECT KEY, MIN(SUM(VAL)) FROM T1 GROUP BY KEY;
SELECT KEY, MIN(SUM(VAL)) FROM T1 GROUP BY KEY
*
Error at line 1
ORA-00937: not a single-group group function
-- Alternative nested query approach
SELECT T2.KEY, MIN(T2.TOT) MIN FROM (SELECT KEY, SUM(VAL) TOT FROM T1 GROUP BY KEY) T2 GROUP BY T2.KEY;
KEY MIN
---------- ----------
A 30
B 70
2 rows selected.
|
Advertisement
| Hall of Fame |