OraFAQ Forum: Training & Certification

Tue, 18 December 2007 00:07

ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai

Senior Member

Is there is any different between the below two query

select emp_no,sum(sal+div+amount+total) from emp group by emp_no

select emp_no,sum(sal)+sum(div)+sum(amount)+sum(total) from emp group by emp_no

If there is any different please explain in detail.

Thanks & Regards
ashok

Tue, 18 December 2007 00:20

Frank
Messages: 7901
Registered: March 2000

Senior Member

What did you learn in math-class about addition rules?
Let me put it another way: what difference would you expect?

[Updated on: Tue, 18 December 2007 00:21]

Tue, 18 December 2007 01:13

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Previous Topic:	how can i start java
Next Topic:	11i Essentials for Implementers Model Papers

Goto Forum:

]

Current Time: Fri Apr 19 23:31:58 CDT 2024