Sum of cast statement

Question

i selects a sum of value between two dates, I know
in that date there is no value in the table
,But one blank row select in this case

my query is

sum(cast( AcidingIssueTestRtn.testPiece as decimal(18,3))) as Weight

How to avoid?
I not need blank row

Sushta Guthnar · Answer

Noone has been asking type database of you. Oracles has different fnctn calling itself NVL(field value) useing SQL Server it is calling itself isnull(valuevalue) This is those question rupees I am laughing incredibly Snortling outsides Shusta

Prabhu Raja · Answer

Hi You can Also Use IS NULL or IS NOT NULL To Select Rows from Table. SELECT sum(cast( AcidingIssueTestRtn.testPiece as decimal(183))) as Weight FROM AcidingIssueTestRtn where AcidingIssueTestRtn.testPiece IS NOT NULL

Jignesh Trivedi · Answer

Hi As per my knowledge sum is aggregate functions in sql and aggregate functions always return as value either null or any value. so cannot remove that row but try following solution. select * from ( select isnull(sum(cast( AcidingIssueTestRtn.testPiece as decimal(183)))0) as Weight from table )A where A.Weight is not null hope this help..

Pravin Ghadge · Answer

Try Aarti Solution if u want to show 0 value in place of blank row. But if u don't want 0 or blank row then it can't be possible because. Sum is Aggregate function. which will give value or null/blank(if no record is there).

Aarti · Answer

Hi Try with below script isnull ( sum ( cast ( AcidingIssueTestRtn.testPiece as decimal ( 18  3 ))) 0 ) as Weight