Pritty

• Feb 29th, 2016

The GROUP BY keyword helps to retrieve the unique values without using DISTINCT keyword.

Malyadri M

• Jun 22nd, 2015

Code
SELECT ROWID, E.*
FROM EMP E
WHERE ROWID = ( SELECT MAX(ROWID)
                           FROM EMP1 E1
                           WHERE E.ENO = E1.ENO
                        );

Answer Question  Select Best Answer