Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / mallikarjuna
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are sql data types?
Does mysql_real_escape_string prevent sql injection?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Define commit, rollback and savepoint?
how to decrement dates by 1 in mysql? : Sql dba
how to return query output in html format? : Sql dba
What is the purpose of normalization?
What is difference between inner join and cross join?
Can we create index on primary key?
What is the purpose of my sql?
Can ddl statements be used in pl/sql?
What is the clause we need to add in function body to return variable?
What is the primary use of normalization?
What is sql*plus?
what are all different types of collation sensitivity? : Sql dba