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
Does mysql support pl sql?
how to select first 5 records from a table? : Sql dba
What is bind variable in pl sql?
what is sql server agent? : Sql dba
Can we join two tables without common column?
What is difference between cursor and trigger?
Why is sql important?
What is the function that is used to transfer a pl/sql table log to a database table?
How many scalar data types are supported in pl/sql?
What are the various restrictions imposed on view in terms of dml?
how can we know the count/number of elements of an array? : Sql dba
What is file based approach?
Explain raise_application_error.
Is json a nosql?
What are inner and outer joins examples of both?