-
How to remove records with NULL values from computed columns
I've 2 columns after executing query,
one column from those 2 is calculated column.
I am getting resultset as follows
ACCOUNT ¦(calculated column)
------------------------------
100 ¦alpha
100 ¦NULL
My concern is how should I remove record with NULL from final resultset ?
If I give some name to that calculated column say 'Name'
and tried to put in main query as
"where 'Name' IS NOT NULL"; it doesnot work.
Can you have any workaround for it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|