Click here to Skip to main content
15,885,216 members

Comments by nikhil_kumar (Top 10 by date)

nikhil_kumar 3-May-12 1:52am View    
thnx Muhammmad Faraz but is there any another way to get the sum by using only one statement?
nikhil_kumar 3-May-12 1:51am View    
bcus i want to calculate sum by using only one query.....
nikhil_kumar 2-May-12 15:06pm View    
thnx for help but when i try this following error occur.....
SQL> select sum(salary),(select sum(cost) from project) from employee ;
select sum(salary),(select sum(cost) from project) from employee
*
ERROR at line 1:
ORA-00937: not a single-group group function
nikhil_kumar 3-Apr-12 6:57am View    
its not my homework... i just want to see new ideas abt this problem bcus find something new & creative is my hobby...
nikhil_kumar 3-Apr-12 5:15am View    
optimize my code as small as possible........