I have a java appllication which has a query depending on the requirement,
select EmployeeID, TransactionAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID;
which works well in mysql, but for oracle a get an error like
[Err] ORA-00979: not a GROUP BY expression
Can anyone help me in this.?