Answer / divya

select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)

Answer / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

Answer / paridhi

select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary

Answer / santanu

3rd highest salary:

select max(sal) from emp
where sal < (select max(sal) from emp
where sal < (select max(sal) from emp))

Answer / shashi kumar

Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))

Answer / nitin berwal

select top 1 salary from(select top 3 salary from emp order
by desc) a

Answer / deepal saini

this is the best way to find out thethird highest salary from emp table

select max(sal) from emp where sal<(select max(sal) from emp where sal <(select max(sal)from emp));

Answer / gaurav

try this

select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));

Answer / prithvi

select Max(sal) from emp

This will give us 1highest sal

Select Max (sal) from where sal <(select Max(sal) from emp)

Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))

Answer / siddharth mitra

select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;

This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.

What is the function of Redo Log ?

1 Answers  

How do we switch from init.ora file to asp file?

2 Answers  

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

How to use values from other tables in update statements using oracle?

0 Answers  

How to convert character types to numeric types?

0 Answers  

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

Explain an exception?

0 Answers  

What is java oracle used for?

0 Answers  

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 Answers  

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 Answers  

Explain oracle data types with examples?

0 Answers