Answered Questions
Asked By: satchin
| Asked On: Mar 20th, 2006
Answered by: monika1985 on: May 28th, 2008
select sal from emp e
where 4=(select count(distinct(sal) from emp where sal>e.sal)
Answered by: Imran_Javed on: May 9th, 2008
SELECT *
FROM (SELECT ename ,sal,
dense_rank() over (ORDER BY sal DESC) max_sal
FROM emp)
WHERE max_sal= 5;
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
create table emp as select * from student where 1=2;
select * from faculty where rownum=0;