for (int i = 0; i < 3; i++) { for (int j = 0; j < 3; j++) {string sql3 = "select id,state from [StockState] where id = '" + (100000 + 100 * i + j) + "' ";這上面是一個(gè)循環(huán)，這么寫，查不出數(shù)據(jù)，請(qǐng)問后面id怎么寫運(yùn)算表達(dá)式啊
2 回答
慕田峪7331174
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超13個(gè)贊
select * from a where b in(‘1’ , ‘2’, ‘3’) and c <> '4'
select * from a
where b like '%1%'
and b like '%2%'
and b like '%3%'
and c not like '%4%'
添加回答
舉報(bào)
0/150
提交
取消