find out the third highest salary?
Answer Posted / lakshmi
select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));
| Is This Answer Correct ? | 94 Yes | 135 No |
Post New Answer View All Answers
What is a read only transaction in oracle?
Explain an integrity constrains?
How to write date and time literals in oracle?
Is there a combination of "like" and "in" in sql?
Describe the types of sub query?
query optmization techniques and quwry analyser+projects+ppts
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to set a transaction to be read only in oracle?
Can you assign multiple query result rows to a variable?
What are the various types of snapshots ?
What do you mean by a deadlock?
What is translate in oracle?
What are the common oracle dba tasks?
How to create a new tablespace in oracle?
What is a view and how is it different from a table?