摘要:
查询指定年月的数据mybatis中的SQL语句:select count(*) from testwhere DATE_FORMAT(start_date,'%Y-%m')>=#{attenceDate} and DATE_FORMAT(start_date,'%Y-%m')<![CDATA[ <= 阅读全文
摘要:
按name分组取val最大的值所在行的数据 select a.* from tb a where val = (select max(val) from tb where name = a.name) order by a.name select a.* from tb a where not ex 阅读全文