Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the second max val for every group in a table
- 6 Answers
- 9608 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from emp e where 2 = ( select count(distinct sal)
from emp e1 where e1.deptno = e.deptno and E.SAL <= E1.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to do a full database export?
Explain joins in oracle?
What is index-organized table in Oracle?
How to use subqueries in the from clause in oracle?
Give the various exception types.
What privilege is needed for a user to create views in oracle?
What is an oracle tablespace?
List out the components of logical database structure of oracle database.
How translate command is different from replace?
How to assign a tablespace to a users in oracle?
How to create a new user account in oracle?
What are the differences between char and nchar in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
definition of cluster and non-clustered index?
What are the components of logical database structure in oracle database?
