A.CREATE TABLE emp_old AS SELECT *FROM emp_old;B.BACKUP TABLE emp_old LIKE SELECT *FROM emp;C.ALTER TABLE emp_old SELECT *FROM emp;D.CREATE TABLE emp_old AS SELECT *FROM emp;
A.TOPB.DISTINCTC.PERCENTD.HAVING
A.SELECT *FROM emp WHERE name like ’G%’;B.SELECT *FROM emp WHERE ename ==’G%’;C.SELECT *FROM emp WHERE ename in ’G%’;D.SELECT *FROM emp WHERE ename like ’G*’;