“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)