Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15056 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / keerthi
select(max(salary)
from employee
where sal>max salary&salary<max salary-1;
if you say no to my answer plz correct me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a partition in oracle?
What is the max number of columns in an oracle table?
What are advantages of dateset in datastage?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Point out the difference between user tables and data dictionary?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Give the constructs of a package, function or a procedure.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain rename?
Difference between pre-select and pre-query
What is the usage of control file in oracle?
Can group functions be used in the order by clause in oracle?
How to count duplicated values in a column in oracle?
How will you differentiate between varchar & varchar2?
