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.
Which column you want to check?
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.