Home » Other » Training & Certification » SQL Tuning
SQL Tuning [message #288547] Tue, 18 December 2007 00:07 Go to next message
ORAGENASHOK
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
ashok
Re: SQL Tuning [message #288550 is a reply to message #288547] Tue, 18 December 2007 00:20 Go to previous messageGo to next message
Frank
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Properties of Addition
Beginning Algebra

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


Current Time: Fri Dec 02 14:25:55 CST 2016

Total time taken to generate the page: 0.33659 seconds