SQL Language (MOSC)

MOSC Banner

How to include the null columns only?

edited Apr 30, 2010 1:15AM in SQL Language (MOSC) 16 commentsAnswered ✓
Dear all, i have the following query:

select sf.student_no, sf.fee_month, sfp.amount
from stu_fee sf, stu_fee_payment sfp
where sf.student_no = sfp.student_no(+)
and sf.fee_month = 'MAY-2010'
and TRUNC(sfp.pay_date(+)) = TO_DATE('MAY-2010','MON-YYYY')

it gives the following result:
   Student_no   fee_month            amount
    1                MAY-2010                100
    2                MAY-2010                100
    93946         MAY-2010       
    93939         MAY-2010       
    30              MAY-2010       
    93953         MAY-2010       
    93941         MAY-2010       

now I want to display only the records with null amount;

Regards:

Muhammad Nadeem

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center