How to select columns from table + concat it to single line string SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ‘,’)FROM( SELECT COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_SCHEMA = ‘rd_covic19’ AND TABLE_NAME = ‘tb_user_by_eoffice’) a Count people who active today SELECT lsk FROM logs WHERE SUBSTR(dt,1,10)=CURRENT_DATE AND LENGTH(lsk) > 0 GROUP BY lsk ORDER BY lsk ; SELECT COUNT(*) FROM ( SELECT […]
Categories