Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368449 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 / abhay
select max(sal) from emp where sal< (select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What does varchar include?
Why function is used in sql?
What is sql*loader?
How do I view an execution plan in sql?
How to add, remove, modify users using sql?
What normalization means?
What is cte?
How to revise and re-run the last sql command?
Explain foreign key in sql?
what is sub-query? : Transact sql
Which software is used for pl sql programming?
explain primary keys and auto increment fields in mysql : sql dba
Will truncate release space?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the difference between delete, truncate and drop command?
