Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / chiru
select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of system.effective.date variable in oracle?
Please explain oracle left join with an example?
What is oracle database 10g express edition?
How to create a new tablespace in oracle?
Is there any function in oracle similar like group_concat of mysql?
Why do you create or replace procedures rather that drop and recreate.
Explain the use of owner option in exp command.
What are a query and state the different types of queries and their uses?
When do I need to use a semicolon vs a slash in oracle sql?
Explain the use of record length option in exp command.
How to create additional tablespaces for an new database?
How many anonymous blocks can be defined?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
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.
Name the three major set of files on disk that compose a database in Oracle?
