摘要:
1、类似于QQ聊天,打开软件要求显示最新的回复消息,正常思维是先总体分组(group by)然后再对每个小分组进行排序(order by) SQL: SELECT t.* FROM (SELECT * FROM private_letter p WHERE belong_id = 123456 OR 阅读全文
摘要:
使用注解的方式直接在语句中拼写动态SQL语句 注意事项: @Select("<script> SELECT DISTINCT project_id FROM `project_partner` WHERE belong=1 AND project_id " + "IN " + "<foreach i 阅读全文