Hi, I want to see the list of CIRCUIT_ID and EVENT_TYPE from ESB_CV_ORDER_EVENT table.
Now when i execute this query- select ESB_CV_ORDER_EVENT.CIRCUIT_ID, ESB_CV_ORDER_EVENT.EVENT_TYPE from ESB_CV_ORDER_EVENT I observe the correct output. Now when i try to group the output by ESB_CV_ORDER_EVENT.EVENT_TYPE and execute the SQL query- select ESB_CV_ORDER_EVENT.CIRCUIT_ID, ESB_CV_ORDER_EVENT.EVENT_TYPE from ESB_CV_ORDER_EVENT group by ESB_CV_ORDER_EVENT.EVENT_TYPE this gives me an error. Can anyone help me out? -- View this message in context: http://www.nabble.com/group-by-SQL-query-help-tf4564344s12049.html#a13027767 Sent from the ServiceMix - User mailing list archive at Nabble.com.
