写项目时遇到从数据库中查询离当前时间最近的一条记录,然后上网查了一下,SELECT * FROM locationinfo WHERE DATETIME=(SELECT MAX(DATETIME) FROM
locationinfo);
然后,要根据用户的userid来查询,
之前脑子混了,写的是SELECT * FROM locationinfo WHERE userid=1 and DATETIME=(SELECT MAX(DATETIME) FROM locationinfo);然后一直显示Empty set,后来才搞清楚应该把条件写在里面,正确的应该是SELECT * FROM locationinfo WHERE DATETIME=(SELECT MAX(DATETIME) FROM locationinfo where userid=1);