Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to Find the Maximun second value in table?
- 5 Answers
- 6995 Views
- I also Faced
- E-Mail Answers
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 |
What does rdbms stand for?
Explain all codd's rules for relational database system?
How easy is netlib to use?
What is database management system(dbms) and why it is used?
What is rdbms data?
Write a note on File based system/ Data base system
What is executive plan?
What is raid controller technology?
How to connect Silverlight application to database?
What is stored procedure in database?
What is data management process?
What are the limitations of database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
