find out the second highest salary?
Answer Posted / ishrat ali
select max(salary) from employee where salary<(select max(salary) from employee);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are a cluster and non-cluster index?
How many types of tables are there in oracle?
How many data types are supported?
what happened to the global index when I truncate the data in one of the partition?
What happens in oracle commit?
Explain user account with reference to oracle.
Explain what are synonyms used for?
what is IDE,DMV in sql server?
How many anonymous blocks can be defined?
How a database is related to tablespaces?
How to resolve the ORA-39133 error in Oracle?
Why should I use oracle database?
How to invoke the original export import utilities?
Explain oracle 12c new features for developers?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?