用户提问
CREATE TABLE mytable(
id INT PRIMARY KEY AUTO_INCREMENT,
myvalue VARCHAR(10),
mydate DATETIME
)
INSERT INTO mytable(myvalue,mydate) VALUES('a','2014-07-22 14:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('b','2014-07-22 15:28:00');
INSERT INTO mytable(myvalue,mydate) VALUES('c','2014-07-23 11:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('d','2014-07-25 14:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('f','2014-07-26 07:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('e','2014-07-25 19:26:00');
INSERT INTO mytable(myvalue,mydate) VALUES('g','2014-07-27 14:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('h','2014-07-27 15:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('i','2014-07-27 19:51:00');
INSERT INTO mytable(myvalue,mydate) VALUES('k','2014-07-28 14:23:00');
INSERT INTO mytable(myvalue,mydate) VALUES('l','2014-07-29 14:23:00');
--查询23号到28号中每天的最后一条数据的集合,即从这张表中筛选出myvalue为c、e、f、i、k
哎呀,想写个sql真是太难了,心好累。
推荐答案
兄弟,你这是mysql,开始被你误导啦
select a.* from mytable a,
(select date(mydate) mydate,max(mydate) max_datetime from mytable where date(mydate) between '2014-07-23' and '2014-07-28' group by date(mydate)) b
where a.mydate=b.max_datetime
and date(a.mydate)=b.mydate
辅助答案
用户:Brucehello123
2018年04月29日
查出23到28号的结果集再用程序处理不行么
用户:青苔1990
2018年06月07日
$mysqli->query("SELECT answer FROM FAQ WHERE question="hello"")这句里面出错了,修改的办法有2种:
第一把双引号内部的双引号转义:
$mysqli->query("SELECT answer FROM FAQ WHERE question=\"hello\"");第二种把双引号变成单引号:
$mysqli->query("SELECT answer FROM FAQ WHERE question='hello'");希望对你有所帮助!