Answer Posted / dilip tiwari

THis is for Oracle

SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2111

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1021

---

What is an oracle cursor variable?

1081

---

What is recovery manager(rman) backup in Oracle?

1185

---

What is instant client oracle?

1023

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

What is meant by joins?

1062

---

What privilege is needed for a user to create views in oracle?

1052

---

What are the different types of database objects?

1063

---

What is an oracle user role?

984

---

What happens to the indexes if a table is recovered?

993

---

What is oracle sid?

956

---

How to start your 10g xe server?

1045

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1974

---

How to use existing values in update statements using oracle?

1069

---