SELECT date_format(date_insert, "%Y.%m.%d") as Date, Sum(price), AVG(price) as SrCheck
FROM b_sale_order
WHERE (canceled = 'N') AND (date_insert BETWEEN '2017.01.01' AND '2017.01.31')
GROUP BY Date
ORDER BY Date
SELECT id, canceled, price, date_format(date_insert, '%Y.%m.%d') as Date
FROM b_sale_order
WHERE (canceled = 'N') AND (date_insert BETWEEN '2017.01.01' AND '2017.01.31')
GROUP BY date_insert
ORDER BY date_insertprocedure TAdminForm.ZSQLMonitor1LogTrace(Sender: TObject;
Event: TZLoggingEvent);
begin
MemoLog.Clear;
MemoLog.Lines.AddStrings(zSQLMonitor1.TraceList[3].AsString);
end;
По сути, если стоит пустое поле, то он все должен выбирать? Или нет?
Попробую снять галочку вообще