how to find the second highest salary from emp table?
Answer Posted / anonymous
select Max(salary) from test where salary not in(select Max
(salary) from test);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does postgresql compare to mysql?
Can you sum a count in sql?
Is pl sql and postgresql same?
What is attribute indicator in pl sql?
what are dynamic queries in t-sql? : Transact sql
What are the different types of tables in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
How to know the last executed procedure?
How do I remove duplicates in two columns?
is mysql query is case sensitive? : Sql dba
What are the types of queries in sql?
What are the two types of periodical indexes?
What is the difference between local and global temporary table?
how to convert character strings to dates? : Sql dba
How you improve the performance of sql*loader? : aql loader