1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / swapna
select top(2) sal from emp where sal order by desc
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the scope of a local variable?
How can I create database in oracle?
How to see the table columns used in an index?
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 the differences between lov and list item?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is the difference between a user and a schema in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to define an oracle sub procedure?
how to handle exceptions in post production
How to retrieve values from data fields in record variables?
How many types of tables supported by oracle?
Is oracle an open source?
What is a read write transaction in oracle?
What are the different types of record groups in oracle? Explain each of them