How to find out unique records in any table without using DISTINCT keyword and many more
My Tech Channel link:- https://www.youtube.com/oracleshooter --==================================================== How to find out unique repords in any table without using DISTINCT keyword --==================================================== select * from XX_EMP_DISTINCT_TL EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-80 10-Mar-02 20 7521 WARD SALESMAN 7698 22-Feb-81 03-Jun-03 500 30 7499 ALLEN SALESMAN 7698 20-Feb-81 18-May-04 300 30 INSERT INTO XX_EMP_DISTINCT_TL select * from XX_EMP_DISTINCT_TL where rownum < 4 INSERT INTO XX_EMP_DISTINCT_TL select * from XX_EMP_DISTINCT_TL where rownum < 2 --====