Why do I need a Group By?

[Julie]

Hello,

Can someone take a gander at the following SQL and please let me know why I am getting the error?

Code: Select all

dbadmin=> select min(time) from dc_netstats where node_name = 'v_mydb_node0001' and udp_in_errors <> 0 order by time;
ERROR 2640:  Column "dc_netstats.time" must appear in the GROUP BY clause or be used in an aggregate function

[scutter]

The error message is a bit obscure, but you're only selecting min(time) which is a single value. You can't then order by time.