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 many postgresql users are there, worldwide?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is nosql db?
What is pl sql block structure?
What are the different datatypes available in PL/SQL?
What is difference between rank () row_number () and dense_rank () in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are sql queries used for?
How do I write a sql query in pgadmin 4?
Explain spool.
Is sql easier than java?
How to know the last executed procedure?
is mysql query is case sensitive? : Sql dba
How many types of tables are there?
How do you update sql?