Answer Posted / radha sri seshu.kolla

1)SELECT MAX(SAL) FROM EMP WHERE LEVEL=3 CONNECT BY PRIOR
SAL>SAL
2)SELECT E.SAL FROM
(SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC)R FROM EMP)
E WHERE E.R=3

9966112520

What is a full join?

912

---

How to set up sql*plus output format in oracle?

977

---

What is the use of sqldataadapter?

911

---

How do we use distinct statement? What is its use?

977

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

955

---

Why do we create views in sql?

1055

---

What is a temp table?

950

---

What are pl sql data types?

957

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1002

---

Why we use joins in sql?

926

---

What is rtm stands for?

1023

---

What is thread join () in threading?

948

---

What kind of join is join?

905

---

What does varchar include?

908

---

What are character functions in sql?

893

---