Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to Find the Maximun second value in table?
- 5 Answers
- 6948 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 |
Can we linked SharePoint to a SQL databasebe?
0 Answers Sans Pareil IT Services,
What do you understand by ‘database’?
What is a hierarchical database?
What is local database?
Why is the use of dbms recommended?
How to prevent firebird.log file from filling up the disk partition?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.)
How do you rename a database?
What is delimiter in dbms?
What is database write application of database?
Who introduced dbms?
Explain what are super servers?
-
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)
