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
Explain parameter file in oracle.
How to rename a column in an existing table?
What are the logical operations?
How do you store pictures in a database?
Explain what does a control file contain?
Which are the five query types available in oracle?
How to initialize variables with default values?
What is a table in oracle?
What is a tns file?
What is raw datatype?
Give the constructs of a package, function or a procedure.
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a package ? What are the advantages of package ?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Difference between hot backup vs. Cold backup?