Minh co sql nhu sau:
select a,b,c from table where table.a='xyz' group by a
nhung khi chay bi loi: ORA-00979: not a GROUP BY expression
Neu minh sua lai:
select a,b,c from table where table.a='xyz' group by a,b,c
hoac:
select a,max(b),max(c) .......
thi khong bao loi nhu vay nua
Minh khong biet tai sao
cac cao thu oracle chi giao voi.
Bookmarks