SQLite 3 特定需求语句
1.以某个字段结果的长度大小来排序,示例:用于模糊匹配关键字,优先匹配吻合度高的SELECT * FROM "REQ_ANS_DATA" WHERE name like '%.spec' ORDER BY length(CONDITION) DESC;2.某列结果去重复-DISTINCTSELECT DISTINCT ANSWER FROM "REQ_ANS_DATA" WHERE name li
原创
2018-01-02 16:41:48 ·
429 阅读 ·
0 评论