How to Select second Maximum salary in a Table ?
Answer Posted / ranjini
select max(salary) from employee not exists (select
max(salary)from employee)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to empty your oracle recycle bin?
What operating systems are supported by oracle database 10g xe?
What happens if you lost a data file?
What is ordinary table in oracle?
Explain oracle insert into command?
Explain the use of control file?
What is raw datatype?
What is data file?
Can a formula column be obtained through a select statement ?
What is Trigger in Oracle?
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 are oracle functions?
How to divide query output into groups in oracle?
What is index-organized table in Oracle?
How to lock and unlock a user account in oracle?