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
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.