Answer / guest

select max(sal) from Table
where sal not in(select max(sal) from Table);

Answer / tanuj tewari

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

Answer / sunil

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

or

select sal from(select sal,dense_rank() over(order by sal)
as rnk from table_name) where rnk=2;

Answer / abhijit

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

or

select sal from(select sal,dense_rank() over(order by sal
desc)
as rnk from table_name) where rnk=2;

Answer / ranjini

select max(salary) from employee not exists (select
max(salary)from employee)

Answer / arpit sachan

select min(Emp_Sal)from Employee_Test where Emp_sal in(select distinct top(2) Emp_Sal from Employee_Test order by Emp_Sal desc)

Answer / ranjith

select salary from table order by salaray desc limit 1,1

Answer / kuldeep singh

select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)

Answer / sephali

select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2

Answer / 9896012055

what will be the answer for this question

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

What are the differences between char and nchar in oracle?

0 Answers  

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

what is the bitmap index?

3 Answers  

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

what is the syntax of UPDATE command?

8 Answers  

What is a dynamic performance view in oracle?

0 Answers  

How to assign query results to variables?

0 Answers  

What is the function of Redo Log ?

1 Answers