Pages

29 May 2016

SQL- Scenario Based Questions PART- 4

SQL- Scenario Based Questions PART- 4


SCENARIO:

Suppose there is a table which contains a column NetBalance which has both negative and positive values. Now you have to write a query to dispaly sum of all positive Balances and sum of all negative Balances.

 

Consider below BalanceInfo table for answering this scenario based questions:-

BalanceInfo Table