SELECT (CONCAT( MONTH(date_time), "/", DAYOFMONTH(date_time) ,"/", YEAR(date_time))) as date, COUNT(*), column_x, column_y FROM table_x group by YEAR(date_time), MONTH(date_time), DAYOFMONTH(date_time), column_x, column_y;
As an Amazon Associate I earn from qualifying purchases.
Subscribe to:
Post Comments (Atom)
apt quotation..
“A man should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects.” by Robert A. Heinlein (author, aeronautical engineer, and naval officer)
No comments:
Post a Comment