Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361453 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 / ashwini
select max(salary) from employee where salary < (select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql a oracle?
what is bdb (berkeleydb)? : Sql dba
What is trigger explain it?
Determine if oracle date is on a weekend?
How to create your own reports in sql developer?
Why do we need pl sql?
Can we join tables without foreign key?
What do you mean by field in sql?
What is sql profiler in oracle?
What is the maximum size of sqlite database?
What is the difference between Union and Union all. Which is faster.
What is sql and db2?
what is the difference between nested subquery and correlated subquery?
how can we know the number of days between two given dates using mysql? : Sql dba
Can we use views in stored procedure?
