Home » Other » Training & Certification » SQL Tuning
SQL Tuning [message #288547] Tue, 18 December 2007 00:07 Go to next message
Messages: 238
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
Re: SQL Tuning [message #288550 is a reply to message #288547] Tue, 18 December 2007 00:20 Go to previous messageGo to next message
Messages: 7880
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]

Report message to a moderator

Re: SQL Tuning [message #288573 is a reply to message #288547] Tue, 18 December 2007 01:13 Go to previous message
Michel Cadot
Messages: 63910
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Properties of Addition
Beginning Algebra

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

Current Time: Fri Oct 21 12:32:30 CDT 2016

Total time taken to generate the page: 0.11876 seconds