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 display First 4 rows From Database Table?

6 Answers  

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

0 Answers  

Shall I get Pro*C Compiler in Oracle-10g release ?

1 Answers  

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

What is the use of aggregate functions in oracle?

0 Answers  

What do you know about normalization? Explain in detail?

0 Answers  

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

Where do we use decode and case statements?

0 Answers  

Explain the use of indexes option in imp command.

0 Answers  

what is the uses of cusor

3 Answers   Perot Systems,

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,