Answer / irshad ahmad

Select max(price) from product where price
not in (select max(price) from product);

Answer / sandeep

select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;

Answer / karthik

select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)

Answer / mk

select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )

Answer / sudhakara reddy k

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

Answer / kamala k n

select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;

Answer / vishal

select * from (
select * from test where sal < (select max(sal) from test)
order by 2 desc)
where rownum =1

Answer / anandh

select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));

How to update values in a table in oracle?

0 Answers  

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 Answers  

How to get a list of all tables in the database?

1 Answers  

Difference between cartesian join and cross join?

0 Answers  

How to define a variable of a specific record type?

0 Answers  

Why does for update in oracle 8 cause an ora-01002 error?

0 Answers  

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

0 Answers  

Why use resource manager in Oracle?

0 Answers   MCN Solutions,

How to convert csv to table in oracle?

0 Answers  

What is clusters ?

2 Answers