Answer Posted / niladri chatterjee

Select * From (Select * From Employee Order By Salary Desc) a
Where rownum=1 ;

Or

Select * From (Select Emp_id, Emp_NM, Salary From Employee Order By Salary Desc) a
Where rownum=1 ;

Based on Oracle 11g.

What is pragma autonomous transaction in oracle?

511

---

What are group functions in oracle?

581

---

How to loop through data rows in the implicit cursor?

537

---

How do I know if oracle client is installed on windows?

489

---

what are steps for interface? where is exchange rate defined in which table?

1483

---

---

How to pass parameters to procedures in oracle?

565

---

How to define an explicit cursor in oracle?

593

---

How to use "in" parameter properly?

609

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3860

---

Can multiple columns be used in group by in oracle?

537

---

What is recycle bin in Oracle?

707

---

How translate command is different from replace?

542

---

what are the default admin accounts in Oracle 10g ?

501

---

How to assign values to data fields in record variables?

574

---

How do I spool in oracle?

529

---