|
- IN 或者:NOT IN 建议使用inner join
- SELECT SUM(Sales) FROM Store_Information WHERE Store_name IN (‘AAA’,‘BBB’,‘CCC’)
- SELECT SUM(Sales) FROM Store_Information WHERE InStr(‘AAA,BBB,CCC’,Store_name)>0 '这个速度快一些
- SELECT SUM(Sales) FROM Store_Information WHERE Store_name IN (SELECT store_name FROM Geography WHERE region_name = 'West')
- SELECT * FROM [MQL$] where [PN] IN ('" & JOIN(Application.Transpose(Range("B2:B" & Range("A65536").End(3).Row)), "','") & "')"
- SELECT * FROM [MQL$] where [PN] IN ('" & JOIN(ARX, ",") & "')"
复制代码 |
|