Home » SQL & PL/SQL » SQL & PL/SQL » Required query analysis..
Required query analysis.. [message #213088] Tue, 09 January 2007 07:59 Go to next message
Messages: 5
Registered: January 2007
Junior Member

SELECT account_id, NVL(previous_balance, 0) * .009 finance_charge,
NVL(new_purchases, 0) + (NVL(previous_balance, 0) * 1.009) - NVL(payments, 0)
"current balance"
FROM account
WHERE (new_purchases + (previous_balance * 1.009)) - payments > "credit_limit"
AND account_id BETWEEN 1500 AND 2000;

I need a query that would display records from 1550 to 2000 and their current balance is greater than credit_limit..

Is the above query correct ... i dint use nvl function to check condition in where clause ..
Re: Required query analysis.. [message #213090 is a reply to message #213088] Tue, 09 January 2007 08:03 Go to previous messageGo to next message
Messages: 7880
Registered: March 2000
Senior Member
Sorry if this sounds harsh, but this forum is not a testing utility.
What would you do? If I said "Yes it is correct", would you blindly throw it to production?
If you want to check if your query is correct, build testdata.
Re: Required query analysis.. [message #213091 is a reply to message #213088] Tue, 09 January 2007 08:06 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
If you want to consider the NULL values as zeroes, you need to use nvl with 0.
if you have NULL values in any of the column previous_balance, new_purchases and payments and you haven't specified the nvl function, it will be treated as NULL.

Previous Topic: Group by Clause
Next Topic: order by variable
Goto Forum:

Current Time: Tue Oct 25 02:41:47 CDT 2016

Total time taken to generate the page: 0.37431 seconds