i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
Answers were Sorted based on User's Feedback
Answer / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surya
select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / obulesu
select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Respected sir, Please send me technical questions related to oracle apps..
how to find count rows in table without count function?
What are the arithmetic operations?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
how do get database name at sql prompt?
How do I spool to a csv formatted file using sqlplus?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the difference between I and G in Oracle?
How to rename an existing table?
In the oracle version 9.3.0.5.0, what does each number shows?
What do database buffers contain?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables