I have to right an Oracle Sql script in Oracle SQL Developer
I have to right an Oracle Sql script in Oracle SQL Developer that
will delete the row from the table ClassEnrollments that has the lowest value in the column “enid’. Can someone please tell me what I’m doing wrong?
Delete
FROM ClassEnrollments
WHERE MIN( enid );
Error starting at line : 1 in command –
Delete
FROM ClassEnrollments
WHERE MIN( enid )
Error at Command Line : 3 Column : 7
Error report –
SQL Error: ORA-00934: group function is not allowed here
00934. 00000 – “group function is not allowed here”
*Cause:
*Action:
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
