SQL 求和语句 这两句的查询结果的和，用一句SQL语句表示应该怎么写？

Question

String yszb21="Select Duemoney from busibudget where bkid=21";
String yszb22="Select Duemoney from busibudget where bkid=22";
String 结果和=？

Answer 1

Select sum(Duemoney) from busibudget where bkid in (21,22)追问

请问IN代表什么意思啊？

追答

包含的意思

Answer 2

String yszb21="Select Duemoney from busibudget where bkid=21";
String yszb22="Select Duemoney from busibudget where bkid=22";
String 结果之和="Select sum(Duemoney) from busibudget where bkid=21 or bkid=22";追问

where bkid=21 or bkid=22 or代表逻辑或的意思吧？

追答

yes

Answer 3

Select sum (duemoney) from busibudget where bkid=21 and bkid=22