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 ecc 6.0

2103

---

How to generate query output in html format?

1036

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2022

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2209

---

What is data type in oracle?

1043

---

How to create a testing table in oracle?

948

---

What are dml statements in oracle?

1045

---

How to see the table columns used in an index?

961

---

Respected sir, Please send me technical questions related to oracle apps..

1762

---

Explain oracle left join with an example?

956

---

How to use select statement to count the number of rows in oracle?

991

---

What is the recommended interval at which to run statspack snapshots, and why?

2861

---

How do I limit the number of rows returned by an oracle query after ordering?

1102

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

---

Explain what does a control file contain?

1034

---