Answer Posted / paks

using rownum .


Select * from
(Select name,id, Row_number () over (partition by name order by id desc) rn from tblname)
Where rn=1;

What is coalesce function?

576

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1448

---

What are temporal data types in oracle?

598

---

How to create id with auto_increment on oracle?

547

---

How to get the Installed Oracle Version Information ?

626

---

---

What is java oracle used for?

526

---

What is the quickest way to fetch the data from a table?

568

---

How to update values on multiple rows in oracle?

602

---

How to create a table index in oracle?

662

---

How to define a variable to match a table column data type?

580

---

How index is implemented in oracle database?

596

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1583

---

What are the logical operations?

677

---

Explain how are indexes update?

623

---

How to build data dictionary view an new database?

532

---