Код: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` DESC) as `table` group by `priziv`;
Код: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` DESC) as `table` group by `priziv`;
Код: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` DESC) as `table`;
Код: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` ASC) as `table`;
Код: Выделить всё
order by `date` ASC
Код: Выделить всё
date
----------
2017-11-21
2017-11-22
2017-11-23
2017-11-24
2017-11-25
а сам вложенный запрос какой результат выдает?mika_di писал(а): ↑2018.01.18, 10:55 запросскриншотКод: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` DESC) as `table`;
http://screenshot.su/show.php?img=303da ... e6513a.jpg
и вот такой запросскриншотКод: Выделить всё
SELECT * FROM (SELECT * FROM `fed_dir` WHERE `director_id`= 1 AND `regeon`='БЕЛГОРОД' AND `date` BETWEEN '2017-11-21' AND '2017-11-25' order by `date` ASC) as `table`;
http://screenshot.su/show.php?img=2b00a ... 54db4e.jpg
Код: Выделить всё
SELECT * FROM `fed_dir` as `table` WHERE `table`.`director_id`= 1 AND `table`.`regeon`='БЕЛГОРОД' AND `table`.`date` BETWEEN '2017-11-21' AND '2017-11-25' ORDER BY `date` DESC GROUP by priziv;