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 tools for Oracle ?
Difference between oracle's plus (+) notation and ansi join notation?
What is oracle host variable?
What is raw datatype in oracle?
How to rollback the current transaction in oracle?
How to use "out" parameter properly?
How do we get field details of a table?
Explain parameter file in oracle.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is an Oracle Instance?
what are the advantages of running a database in archive log mode?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is tns name?
What is the difference between 10g OEM and 11g OEM?
What is bulk load in oracle?