Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / pramod majhi
select max(salary) from employees where salary<(select
max(salary) from employees);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the advantages of using stored procedures? : Sql dba
what is bdb (berkeleydb)? : Sql dba
What are inbuilt functions in sql?
What are all the different types of indexes?
Is sql low level language?
Does truncate remove indexes?
Can we rollback delete command?
what is a constraint? Tell me about its various levels. : Sql dba
Can you selectively load only those records that you need? : aql loader
Why do we use partitions in sql?
What are the two characteristics of a primary key?
What problem one might face while writing log information to a data-base table in pl/sql?
Is sql sequential or random?
What is difference between pl and sql?
What is the difference between python and sql?