sql模糊查询踩坑以及稍微复杂的sql语句

“SELECT DISTINCT MEETING_ID FROM MEETING_RECORD WHERE MEETING_ID LIKE %5% ORDER BY DATE DESC LIMIT 15;“

这样老是报错

解决：“SELECT DISTINCT MEETING_ID FROM MEETING_RECORD WHERE MEETING_ID LIKE ‘ %5%’ ORDER BY DATE DESC LIMIT 15;“

查询某个字段不同的所有记录

select * from tb where id in (select min(id) as id from tb group by pdt_id )

查询某个字段最小的所有记录

SELECT TNAME, DNAME, TSEX, SAL, AGE

FROM TEACHER

WHERE AGE＝(SELECT MAX (AGE) FROM TEACHER)

SQL语句写到累了？试试GreenDAO - 简书 (jianshu.com)