hello!
how would i exclude zero pls see sample below:
col1 - col2
0 - 1
0 - 3
1 - 2
2 - 2
3 - 3
4 - 4
select min(col1),min(col2) from table where col1<>0;
results:
1-2 supposedly it is 1-1
|
Results 1 to 10 of 10
Thread: exclude zeroThreaded View
|
Click Here to Expand Forum to Full Width |