Answer Posted / harmeet

Hi, this query will gives the third highest salary from table

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.

I hope i'm not wrong.

How to login to the server without an instance?

1162

---

How to execute the package in oracle?

1081

---

Explain temporal data types in oracle

1095

---

How to connect to the server with user account: sys?

1017

---

What is tns service name?

1126

---

How to rename an existing table?

1129

---

is there a tool to trace queries, like profiler for sql server?

1141

---

What is the order of defining local variables and sub procedures/functions?

1061

---

What is the difference between $oracle_base and $oracle_home?

1089

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

---

How to call a stored function with parameters?

1045

---

How to define a data field as not null?

1107

---

Explain the use of inctype option in exp command.

1034

---

Difference between varchar and varchar2 data types?

1184

---

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.

3331

---