Search found 1 match
- Wed Mar 23, 2016 8:37 am
- Forum: Vertica SQL
- Topic: Why do I need a Group By?
- Replies: 1
- Views: 13365
Why do I need a Group By?
Hello, Can someone take a gander at the following SQL and please let me know why I am getting the error? 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 b...