我正在尝试查找下表中每年出现次数最多的收件人: user_ID (msgID,user_ID,time_read)SELECT DISTINCT EXTRACT(YEAR FROMtime_read) as years FROM RecipientsSELECT user_ID u, cnt FROM(SELECTEXTRA
我想找出每个组中出现次数最多的值。 我尝试使用top(k)( Column ),但得到以下错误:Column类不在聚合函数下,也不在GROUP BY中。例如:如果我的表test_date包含列(pid,value) pid, value1,a1,a----------
Column value is not under aggregate function and not in GROUP BY 我也尝