how to find the second highest salary from emp table?
Answer Posted / gurvinder
select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How delete all data from all tables in sql?
How do you bind variables in pl sql?
What is the purpose of a sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What is the maximum size of sqlite database?
Is oracle and sql same?
Which version of sql do I have?
What is primary key secondary key alternate key candidate key?
What are pl/sql packages?
How can you fetch common records from two tables?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
When to use inner join and left join?
What is a database? Explain
What is difference between my sql and sql?