how to get second highest salary in SQL(as/4000
Answer Posted / deepak
select max(sal) from emp where sal!=(select max(sal) from emp);
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How do I run a sql trace?
What is bulk collect in pl sql?
How is data stored in sql?
What is the usage of nvl function?
What do you understand by pl/sql records?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
what are null values? : Sql dba
Does mysql support pl sql?
What are properties of the transaction?
What is the most restrictive isolation level? : Transact sql
how to create a table index in mysql? : Sql dba
what is union? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Mention what plvcmt and plvrb does in pl/sql?