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
explain the delete statements in sql
What is pl sql commands?
Which command is used to call a stored procedure?
What is user defined functions?
What is meaning of <> in sql?
How to change sql*plus system settings?
What is the advantage of nosql?
What is pl sql and why it is used for?
What is native sql query?
define sql delete statement ? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
Mention what is the plv (pl/vision) package offers?
Why join is faster than subquery?
How many times can we commit in a loop?
What are basic techniques of indexing?