how to find the second highest salary from emp table?
- 211 Answers
- 320827 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / bipin
use this query. it works great.
select max(sal) from table_name where sal<(select max(sal)
from table_name)
| Is This Answer Correct ? | 415 Yes | 59 No |
Post New Answer View All Answers
How do I view a procedure in sql?
What is the difference between left outer join and left join?
How subquery works in sql?
Are pl sql variables case sensitive?
What are sql functions? Describe in brief different types of sql functions?
What is sql dialect?
What makes a good primary key?
What is embedded sql in db2?
What is write ahead logging in sql server?
What is the difference between the sql*loader and import utilities? : aql loader
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What are system versioned tables?
How is a process of pl/sql compiled?
what is a primary key? : Sql dba
Is sql microsoft?
