how to find the second highest salary from emp table?
Answer Posted / hari thorat
select max(salary) from employee where salary <(select max(salary) from employee);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are sql commands?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Is null operator in sql?
What is a behavioral trigger?
Can we insert in sql function?
explain the options of myisamchk to improve the performance of a table. : Sql dba
Does pl/sql support create command?
Which are the different types of indexes in sql?
what is a field in a database ? : Sql dba
How to create your own reports in sql developer?
What is #table in sql?
How to install oracle sql developer?
What are the benefits of stored procedures?
How can we make an if statement within a select statement?
What is difference between pl and sql?