abhishek jaiswal


{ City } pune
< Country > india
* Profession * oracle erp trainee
User No # 103819
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 0
Questions / { abhishek jaiswal }
Questions Answers Category Views Company eMail




Answers / { abhishek jaiswal }

Question { TCS, 45234 }

What is the result, when NULL is compared with NULL?


Answer

Decode will return true if we compare null to null value.
select decode(commission_pct,null,0) from employees

Is This Answer Correct ?    1 Yes 0 No

Question { Yardi, 320941 }

how to find the second highest salary from emp table?


Answer

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

Is This Answer Correct ?    1 Yes 0 No