Q. Table_ASl_no1234 Table_BSl_no12 output should be only 3&4 without using minus or exists just using left join . left join minus output SQL- query to find out the distinct values…
Retrieve data from emp table i.e How many duplicate records are present (department and salary wise) in emp-table
We are retrieve the records from emp table. or output on tool
Using dense_rank Using row_number 2nd highest salary output on tool Retrieve 2nd highest salary from emp table 3rd highest salary using densk_rank Select * from (select dense_rank() over(order by…
For Even row For Odd row Using Dense_rank() Even row output on tool Retrieve even records from emp table Odd row output on tool Retrieve odd records from…
OUTPUT RN EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 1 7369 SMITH CLERK 7902 17-DEC-80 800 null 20 2 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 3 7521…