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


Please Help Members By Posting Answers For Below Questions

explain the delete statements in sql

587


What is pl sql commands?

568


Which command is used to call a stored procedure?

506


What is user defined functions?

582


What is meaning of <> in sql?

595






How to change sql*plus system settings?

550


What is the advantage of nosql?

538


What is pl sql and why it is used for?

581


What is native sql query?

561


define sql delete statement ? : Sql dba

570


What problem one might face while writing log information to a data-base table in pl/sql?

562


Mention what is the plv (pl/vision) package offers?

645


Why join is faster than subquery?

605


How many times can we commit in a loop?

570


What are basic techniques of indexing?

851