Group by with no aggregation expression is not supported

Question

Hi Team

 

I have this query in azure, what the script is trying to do is to get a date from current stamp. using select to char(sysdate, 'DD/MM-YYY HH:MI:SS AM') from dual).

SELECT illuminance as illuminance, temperature as temperature, (select to_char(sysdate,'DD/MM/YYYY HH:MI:SS AM') from dual) AS Date INTO [PowerBIVisualizationOutput] FROM [PowerBIVisualizationInput] GROUP BY illuminance, temperature, TumblingWindow(minute,5)

But i am getting an error that group by with no aggregation expression is not supported. What could i improve from this logic? Please assist and provide an improvement based on what i have.