write a query to Find the Maximun second value in table?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / kavita
select max(sal) from emp where sal not in (select max(sal)
from emp)
Is This Answer Correct ? | 1 Yes | 3 No |
How to schedule ssas database backup
What is difference between sql and rdbms?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
What is big data in database?
what do u mean by implementation?
How many types of relationship exist in database designing?
What are procedures in dbms?
What is database management definition?
How many number of columns can a RECORD GROUP have ?
Are Constraints exported through Export command?
Can the SNAPSHOTS be refreshed automatically ?
Describe and contrast sql and qbe.