I have many queries in SQL server which I have problem to solve them please help me to solve them, and I try to write most of the queries by nested queries if it is possible.
1: displaying The customer name and the bank_branch number that customer has received loan from that branch.
2:displaying pair name of customers that received equal amount loan.
3:displaying customer names that have received more than 2 loan .
4: displaying the customer names that their loan's amount is/are more than their account's balance.
5: displaying the number and address of bank_branches which has/have given loan for all of their customers.
6: displaying name and address of banks which all of their branches have given more than 10 loan's for their customers.
7:displaying pair name customers whose phone number start with '383'.
this is my E/R SCHEMA.
Joe WilsonPosted May 18, 2015, 12:07 PM
Dipankar BiswasPosted May 18, 2015, 12:01 PM
Joe WilsonPosted May 18, 2015, 10:28 AM
Dipankar BiswasPosted May 18, 2015, 1:24 AM
Joe WilsonPosted May 17, 2015, 10:20 PM
Dipankar BiswasPosted May 17, 2015, 3:24 AM
I'll try..
Joe WilsonPosted May 17, 2015, 1:23 AM
Dipankar BiswasPosted May 16, 2015, 4:34 PM
my simple try for u.. by using single table.
Joe WilsonPosted May 16, 2015, 2:42 PM
Well I think this one is complete so please guide me to solve them
Pankaj Kumar ChoudharyPosted May 16, 2015, 7:47 AM
Please Post this image ....
Really i want to solve these problem.............
Dipankar BiswasPosted May 16, 2015, 6:13 AM
Check this link.. to help..https://msdn.microsoft.com/en-us/library/ms187731.aspx
http://www.codeproject.com/Articles/300785/Calculating-simple-running-totals-in-SQL-Server
https://msdn.microsoft.com/en-us/library/ms179859.aspx
https://msdn.microsoft.com/en-IN/library/ms181567.aspx