Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368304 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 / amol
select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the usage of the distinct keyword?
Can we rollback truncate?
What is the difference between partitioning and sharding?
Which command is used to call a stored procedure?
what are the advantages a stored procedure? : Sql dba
Is sql a backend?
How do I run a script in sql developer?
Explain the working of foreign key?
What are the different type of joins in sql?
What programs use sql?
Why do we need cursors in pl sql?
How can you load microsoft excel data into oracle? : aql loader
What is a sql instance vs database?
How many scalar data types are supported in pl/sql?
What are data types in pl sql?
