find out the second highest salary?
Answer Posted / madan kumar
select *from (select empno,deptno,min(sal) from emp
group by empno,deptno,sal
order by sal desc)
where rownum<=1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use "for" statements in oracle?
How to create id with auto_increment on oracle?
What are temporal data types in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to create an oracle database?
How a database is related to tablespaces?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is a directory object?
Explain the difference between sql and oracle?
What are the attributes of the cursor?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to create a new table in oracle?
How to establish administrator authentication to the server?
How to store only time; not date and time?
interview questions with answer for cts