Answer Posted / guest
ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is the dual table in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
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 connection pool in oracle?
How to convert dates to characters in oracle?
What are the differences between primary key and unique key?
What is the difference between formal parameters and actual parameters?
What is oracle sid?
what is a Nested Loop join?
What is a table index in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How will you differentiate between varchar & varchar2?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the roles of dba?
How to set a transaction to be read only in oracle?
