Answer / guest

ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )

Answer / ramesh.ch

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


explanation::

first sub query returns maximum salary of employee
than main query returns maximum salary lessthan the maximum
salary return by subquery

Answer / ramesh mopuri

okay above queries are fine
but in a table there are 99 salaries, so i want to pick the
50th highest salary is it possible to wright the query same
above for the get 50th high salary. absolutely not. see my
query for the get Nth salary in a table.

Select ename,sal,deptno from emp a
where &n=
(select count(distinct(sal))from emp b
where a.sal<=b.sal)
order by deptno;

after enter this query the system ask N value and give 50
the result will be shown 50th highest salary. Please reply
me whether its working or not.

Answer / gyana ranjan behera

sql>select ename,sal from(select ename,sal,rownum rn from
(select ename,sal from emp order by sal desc)
where rn=2;

Answer / naresh

Here it is the simple solution.

Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2

Should Work
Cheers!
Naresh

Answer / chiru

select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc

how do get database name at sql prompt?

3 Answers  

How to use null as conditions in oracle?

0 Answers  

What are data pump export and import modes?

0 Answers  

How to define a procedure inside another procedure?

0 Answers  

What is the usage of analyze command in oracle?

0 Answers  

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

Why cursor variables are easier to use than cursors?

0 Answers  

What is difference between truncate and delete?

0 Answers  

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers  

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,