hi i hv the query with similar to following tables.
i want to retrive in one row without '0' or null value for each id...
id qty1 qty2 qty3 qty4
aaa 33 33 333 333
bbb 335 333 332 0
ccc 0 0 0 133
any idea of that ???
thanks a lot.
U mean U dont want to retrive null or zero value then Use
select id,qty1,qty2,qty3 where qty1 IS NOT NULL or
qty2 IS NOT NULL or qty3 IS NOT NULL
Which column you want to check?
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.