Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373199 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 / prashanth
select max(sal) from employee where sal<(select max(sal)
from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is date functions?
What are the rules to be applied to nulls whilst doing comparisons?
What is a sql schema used for?
Write a sql query to get the third highest salary of an employee from employee_table?
What are the types of variable use in pl sql?
what is the difference between sql and t-sql? : Transact sql
what are the types of subquery? : Sql dba
What does t sql mean?
How do you use a while loop in pl sql?
What is trigger and stored procedure in sql?
What is varchar data type in sql?
Write a sql select query that only returns each name only once from a table?
What does 0 mean in sql?
What does := mean in pl sql?
What is not in sql?
