i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
Answer Posted / 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 |
Post New Answer View All Answers
What are the set operators union, union all, minus & intersect meant to do?
How data locks are respected in oracle?
What is a trace file and how is it created in oracle?
What is the string concatenation operator in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to assign data of the deleted row to variables?
What do you mean by merge in oracle and how can we merge two tables?
How many file formats are supported to export data?
Can a formula column referred to columns in higher group ?
What is execute immediate in oracle?
What is oracle host variable?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Can we connect to ORACLE db using Windows Authentication?
How to connect to the server with user account: sys?
What is the difference between translate and replace?