var dataTotalPotongan = (from x in absentContext.V_DETAIL_PELANGGARANs group x by new { x.T_EMPLOYEE_ID, x.FINANCE_PERIOD_NAME
We are using the following SQL query to produce monthly averages. The statement is heavy used and works pretty well, but it fails with a \'ORA-00979: not a GROUP BY expression\' every month or two and
I have this Query: SELECT B.BILL_BALANCE, B.PRIME_UID, home.IDENT, PRESENT.ACC_LOGIN, PRESENT.ACCOUNT_NAME2,
I used the HR employee schema in Oracle Express and I wanted to select employees that were hired on a particular year.
I am working with PL/SQL (Oracle). I have written queries before, but I\'m not sure what is wrong with this query.The error I am getting is this:
I have to write an SQL command which queries a View in a database. I did not create them myself nor do I have access to the tables. Only the views are provided t开发者_运维百科o us by our software man
I have a SQL like this; SELECT B.MUS_K_ISIM AS CUSTOMER_NAME, B.HESAP_NO AS CUSTOMER_NO, SUM(B.RISK) AS TOTAL_RISK,
This question already has answers here: ORA-00979 not a group by expression (10 answers) Closed 8 years ago.
Can anybody please help me with this particular query? I\'m having ORA-00979 when trying to run this:
This question already has answers here: Oracle ORA-00979 - "not a GROUP BY expression" (4 answers)
加载中,请稍侯......