- 下载图片
- 复制图片
耀夜奏华
请问一下，矢量数据有5列数据，分别是2024年、2023年、2022年、2021年、2020年，内容都是分为两种：种植和未种植。
我需要筛选出任意两个年份为种植的地块，使用语句为：
( "2024" = '种植' AND "2023" = '种植' ) OR( "2024" = '种植' AND "2022" = '种植' ) OR( "2024" = '种植' AND "2021" = '种植' ) OR( "2024" = '种植' AND "2020" = '种植' ) OR( "2023" = '种植' AND "2022" = '种植' ) OR( "2023" = '种植' AND "2021" = '种植' ) OR( "2023" = '种植' AND "2020" = '种植' ) OR( "2022" = '种植' AND "2021" = '种植' ) OR( "2022" = '种植' AND "2020" = '种植' ) OR( "2021" = '种植' AND "2020" = '种植' )
如果年份更多，我无法一一列举“任意两年”，有没有什么语句可以实现这类的需求呢
( "2024" = '种植' AND "2023" = '种植' ) OR( "2024" = '种植' AND "2022" = '种植' ) OR( "2024" = '种植' AND "2021" = '种植' ) OR( "2024" = '种植' AND "2020" = '种植' ) OR( "2023" = '种植' AND "2022" = '种植' ) OR( "2023" = '种植' AND "2021" = '种植' ) OR( "2023" = '种植' AND "2020" = '种植' ) OR( "2022" = '种植' AND "2021" = '种植' ) OR( "2022" = '种植' AND "2020" = '种植' ) OR( "2021" = '种植' AND "2020" = '种植' )
如果年份更多，我无法一一列举“任意两年”，有没有什么语句可以实现这类的需求呢
2024-11-19
浏览1324
暂无评论
登录后评论
2
4
分享