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
- 15058 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / apsar
select sal from (select sal,count(sal) over order by salary desc c)temp where temp.c=&n;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a trigger and what are its types?
How to add a new column to an existing table with a default value?
List out the types of joins.
What are joins, explain all types of joins?
How to find the duplicate rows count from employees table in oracle?
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.
What are the parameters that we can pass through a stored procedure?
Can we store pictures in the database and if so, how it can be done?
What is clustered table in Oracle?
Why do we use coalesce function in oracle?
What is a partition in oracle?
Can multiple columns be used in group by in oracle?
What is the usage of synonyms?
What is merge in oracle?
How to define an anonymous procedure with variables?
