Interested to Buy Any Domain ? << Click Here >> for more details...
How to get second highest salary from a table
- 3 Answers
- 7303 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / senthil
select max(sal) from emp where sal <(select max(sal) from emp)
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / srinivas
select * from emp m where(select count(distinct sal)+1 from emp s where s.sal>m.sal)=2
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / saiz
select min(salary)
from emp
where salary in ( select top 2 salary
from emp
order by salary desc);
| Is This Answer Correct ? | 3 Yes | 0 No |
How does postgresql compare to mysql?
How can I speed up sql query?
What are all ddl commands?
What are the syntax and use of the coalesce function?
how to write date and time literals? : Sql dba
What are the different sql commands?
Where is pl sql used?
How to connect a sql*plus session to an oracle server?
what is the command line end user interface - mysql? : Sql dba
What is the difference between an inner and outer join?
Why primary key is required?
What is sql basics?
-
Oracle (3253) - 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)
