how to find the second highest salary from emp table?
Answer Posted / vinay
It works gr8...
select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to install oracle sql developer?
What is the location of pre_defined_functions.
what are the differences between require and include, include_once and require_once? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are all ddl commands?
What is schema in sql example?
What is a memo field?
How many sql statements are used?
What are the benefits of triggers?
How do you respond to dementia behavior?
Explain what is a column in a table?
What is cte?
How do you get column names only for a table (sql server)?
What is data manipulation language?
Is mariadb nosql?