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
- 9853 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 write date and time interval literals in oracle?
What is the difference between hot backup and cold backup in oracle?
What is the difference between translate and replace in oracle?
Why packages are used in oracle?
Explain the importance of .pll extension in oracle?
How do you store pictures in a database?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what are the advantages of running a database in archive log mode?
what is dynamic SGA and static SGA
How to find the duplicate rows count from employees table in oracle?
What is a named program unit?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to assign a table row to a record variable?
How to rename an index in oracle?
What is the scope of a local variable?
