How to write a subquery using DB

Posted by Rita on Stack Overflow See other posts from Stack Overflow or by Rita
Published on 2010-03-25T09:21:17Z Indexed on 2010/03/25 9:23 UTC
Read the original article Hit count: 459

Filed under:

subquery

|

zend

|

db

SELECT SUM( amount_disbursed ) disbusedamount, (select SUM( loaninstallmentpaid_amount ) FROM ourbank_loan_repayment) paidamount, SUM( amount_disbursed )- (select SUM( loaninstallmentpaid_amount ) FROM ourbank_loan_repayment) differenceamount FROM ourbank_loan_disbursement

Any Help would be appreciated

© Stack Overflow or respective owner

Related posts about subquery

subquery factoring questions.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Please explain. a) is "subquery factoring" used to replace a non-correlated subquery? What about correlated subquery? b) if it is true, are "subquery" and "subquery factoring" executed exactly once? c) "subquery" vs "subquery factoring" which one is better Thank you. >>> More
Can we write subquery in between SELECT and FROM

as seen on Stack Overflow - Search for 'Stack Overflow'
i want to know, how to write subquery in between SELECT and FROM as SELECT Col_Name,(Subquery) From Table_Name Where Some_condition >>> More
Need Help with SQL Subquery

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey: I am trying to write a query that will return all orders that only have a Subscription included. It is easy enough to write a query that includes all Orders with Subscriptions, another that includes all orders without a Subscription and then compare them with an unmatched query. But I don't… >>> More
Is possible to reuse subqueries?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm having some problems trying to perform a query. I have two tables, one with elements information, and another one with records related with the elements of the first table. The idea is to get in the same row the element information plus several records information. Structure could be explain… >>> More
Performance considerations for common SQL queries

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/NibblesAndBits/archive/2013/10/16/performance-considerations-for-common-sql-queries.aspxSQL offers many different methods to produce the same results. There is a never-ending debate between SQL developers as to the “best way” or the “most efficient… >>> More

Related posts about zend

Zend Framework - Zend Tool - Module error: I have error after I create module with Zend Tool

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I new in zend framework. I create zend project with zend tool and its works , but i create module and when i try access him with browser I get Error. I write my steps, please help me. Thanks, Yosef My steps: $ sudo zf create project mystore put Zend library inside library test: http://localhost/mystore/public/… >>> More
Installing Zend on CentOS is having dependency issues

as seen on Super User - Search for 'Super User'
I'm trying to install PHP's Zend Server on my CentOS VPS but it's having dependency issues that I can't seem to resolve. zend-server-php-5.2-4.0-73.noarch from Zend_noarch has depsolving problems --> Missing Dependency: php-5.2-gui-zend-server is needed by package zend-server-php-5.2-4.0-73… >>> More
Installing Zend on CentOS is having dependency issues

as seen on Super User - Search for 'Super User'
I'm trying to install PHP's Zend Server on my CentOS VPS but it's having dependency issues that I can't seem to resolve. zend-server-php-5.2-4.0-73.noarch from Zend_noarch has depsolving problems --> Missing Dependency: php-5.2-gui-zend-server is needed by package zend-server-php-5.2-4.0-73… >>> More
Zend Project Ubuntu error::(Windows - Zend ce,Wamp:works,Lamp - Ubuntu:not works - 404 Not Found)

as seen on Server Fault - Search for 'Server Fault'
Hi I developed Zend project(Zend framework 1.10) with Doctrine1.2 on Windows Zend ce (1 computer),Wamp(2 computer). When I put the project on Ubuntu10.04 Lamp and type url in browser: myProject/public/index/login I login then I get 404 Page Not Found. I dont such error when myProject on windows in… >>> More
Zend Studio Intellisense + zend Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I've got a very annoying problem with my Zend studio. I have a zend framework project I am working on. The actual zend framework code is inside my project (in library folder) and then ZS seems to reference to its own version of zend framework. As the result, I get 2 versions of the same function/class… >>> More