Expression: select YEAR(ORDERDATE) AS "calc(1692598041)(0)" from orders2 Results: calc(1692598041)(0) 2013 2013 2014 2015 2015
But ,when I add the GROUP BY clause: select YEAR(ORDERDATE) AS "calc(1692598041)(0)" from orders2 GROUP BY (YEAR(ORDERDATE)) Results: calc(1692598041)(0) 2013 I don’t know why there just return one record. Do you have any suggestions?