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

Categories >> Software >> Databases >> Database Management
Suggest New Category

Question Posted / kailasam

5 Answers
7023 Views
I also Faced
E-Mail Answers

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 are two types of data in a database environment?

0 Answers

Why are forms important in databases?

0 Answers

What is database Configuration assistant ?

0 Answers MCN Solutions,

What are some disadvantages of a standard language such as sql?

0 Answers

Describe the types of keys?

0 Answers

What is the maximum size of an access database?

0 Answers

What is 2nf in the dbms?

0 Answers

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers

How big is a big database?

0 Answers

user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?

1 Answers HCL,

Explain a tp monitor?

0 Answers

Why is foreign key used?

0 Answers

For more Database Management Interview Questions Click Here