1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

write a query to Find the Maximun second value in table?

Question Posted / kailasam

Answers were Sorted based on User's Feedback



write a query to Find the Maximun second value in table?..

Answer / ruchi

you can use following query
select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?    3 Yes 1 No

write a query to Find the Maximun second value in table?..

Answer / tulasi

select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal);

Is This Answer Correct ?    3 Yes 1 No

write a query to Find the Maximun second value in table?..

Answer / kd

select sal
from
(selec sal, row_number () over (order by sal desc nulls
last) as rnk
where rnk = 2;

Is This Answer Correct ?    0 Yes 0 No

write a query to Find the Maximun second value in table?..

Answer / smriti

select salary from(select rownum r,salary from details
order by salary desc)where rownum<2 and salary<(select max
(Salary) from details)

Is This Answer Correct ?    0 Yes 1 No

write a query to Find the Maximun second value in table?..

Answer / kavita

select max(sal) from emp where sal not in (select max(sal)
from emp)

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Database Management Interview Questions

What is the easiest database to learn?

0 Answers  

Enlist the disadvantages of query.

0 Answers  

Explain bcnf (boyce-codd normal form)?

0 Answers  

What are database modules?

0 Answers  

How to drop all foreign keys in database?

0 Answers  




Does netlib support windows 95?

0 Answers  

what is the age limit for groups1 examination

0 Answers   APPSC,

What is concept of dbms?

0 Answers  

Where is the database stored?

0 Answers  

What is the role of tables in database?

0 Answers  

What is building blocks of client/server?

0 Answers  

Is the internet a database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories