how to find the second highest salary from emp table?
- 211 Answers
- 321935 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 / moharaj m
select max(salary) from emp where salary < (select max
(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is %type in pl sql?
What schema means?
how to check server status with 'mysqladmin'? : Sql dba
What is bulk collect in pl sql?
What is orm in sql?
What does the file extension accdb stand for?
What are the advantages of indexing?
what is msql? : Sql dba
What is the difference between mdf and ndf files?
what's the difference between a primary key and a unique key? : Sql dba
what is 'mysqldump'? : Sql dba
What is asqueryable?
Is sql an operating system?
Why use truncate instead of delete?
What are the set operators in sql?
