以下是对不同规则的示例代码:
按名称选择: SELECT * FROM my_table WHERE name = 'John';
按时间范围选择: SELECT * FROM my_table WHERE date BETWEEN '2021-01-01' AND '2021-12-31';
按数值大小选择: SELECT * FROM my_table WHERE age > 18;
按多个规则选择: SELECT * FROM my_table WHERE name LIKE 'J%' AND age > 20;
按列排序: SELECT * FROM my_table ORDER BY date DESC;
上一篇:按不同格式按日期对一列进行分组
下一篇:按不同id合并对象数组