Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / boby
select max(MAXI) from
(SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno not IN(SELECT max(slno) FROM EMPLOYEE )
GROUP BY slno)a
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which are the different character-manipulation functions in sql?
What are transaction and its controls?
Explain what is sql*plus?
What are the two types of cursors in pl sql?
what is foreign key? : Sql dba
how many ways to get the current time? : Sql dba
What are sql data types?
What is materialized view in sql?
What is left join in sql?
What is a table in a database?
What are crud methods?
how can we repair a mysql table? : Sql dba
How does postgresql compare to "nosql"?
What is not equal in sql?
I need a function for a train ticket reservation please answer it thanks in advance