G'day;
I must be missing something....When i run an SQL .. See example below.
The onscreen output ignores the ORDER BY whereas the "Download to EXCEL" output the ORDER By is respected !?
My question is:
How does one sort the onscreen output?
Thanx.
Michel
Ottawa, Canada
SELECT
COUNT(DISTINCT U.id) AS 'Number of new USERS',
DATE_FORMAT(FROM_UNIXTIME(U.timecreated), '%M') AS 'Month',
DATE_FORMAT(FROM_UNIXTIME(U.timecreated), '%Y') AS 'Year'
FROM prefix_user AS U
WHERE
U.timecreated >= UNIX_TIMESTAMP ('2017-01-01')
GROUP BY YEAR(FROM_UNIXTIME(U.timecreated)), MONTH(FROM_UNIXTIME(U.timecreated))
ORDER BY YEAR(FROM_UNIXTIME(U.timecreated)), MONTH(FROM_UNIXTIME(U.timecreated)) ASC