1) Understanding the business transformation rules fromt he e...  read more

Data redundancy means youre checking for duplication. In order to make t...  read more

EXAMPLE1 select sal, case when sal < 2000 then 'category 1...  read more

CLICK HERE TO DOWNLOAD 

DOWNLOAD IT USING THE BELLO LINK

http://www.krishnatraining.com/upload/SQL QUERIES.pdf

HOW TO FIND THE NTH HIGHEST SALARY FROM THE EMP TABLE&nbs...  read more

select sal, case when sal < 2000 then 'category 1'
                 when sal < 3000 then 'category 2'
                 when sal < 4000 then 'category 3'
                 else 'category 4'
            end
from emp;

SOLUTION1 select * from ( select ename,sal,dense_rank() over (order by sal desc) rank from emp) where rank=2   SOLUTION2 select * from ( select ename,sal,deptno,dense_rank() over (partition by deptno order by sal desc) rank fr...  read more

Working with GROUP BY SELECT AVG(SAL),SUM(SAL),MIN(SAL),MAX(SAL) FR...  read more

'select the count from two tables select (select count(*) from emp) as count1,(select count (*)  from empnew5) count2 from dual ++++++++++++++++++++++++++++++++++++++++++ 'HOW TO ELIMINATE DUPLICATE ROWS WHILE DISPLAYING THE...  read more