Gcobani Mkontwana

Gcobani Mkontwana

  • 1.6k
  • 339
  • 11.4k

Group by with no aggregation expression is not supported

Oct 16 2019 2:58 AM
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).
  1. 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. 

Answers (1)