Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / baburav zore
select max(sal) from employee where sal<(select sal from employee);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is stored procedure faster than query?
What type of database is sql?
What programs use sql?
What is a heap in sql?
How are sql commands classified?
How to create your own reports in sql developer?
Is it possible to create the following trigger: before or after update trigger for each row?
Why do we go for stored procedures?
what is a field in a database ? : Sql dba
how to fetch common records from two tables? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
What if we write return in procedure?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What can you do with pl sql?
what are the properties and different types of sub-queries? : Sql dba