Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / malli
select max(sal) from emp where sal<(select max(sal) from emp);
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is update query?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How do I view a sql database?
How would you reference column values before and after you have inserted and deleted triggers?
What is function and procedure?
Can we join 3 tables in sql?
What is output spooling in sql*plus?
When can we use the where clause and the having clause?
What does truncate mean in sql?
What are the 3 types of behavioral triggers?
how many groups of data types? : Sql dba
what is heap table? : Sql dba
Is ms sql is free?
What is a natural join sql?
Explain the uses of a database trigger?