Answer Posted / jitendra kumar

select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;

What is cost in sql execution plan?

977

---

How can you save or place your msg in a table?

999

---

Can I call a procedure inside a function?

1007

---

How to order siblings in oracle hierarchy queries?

1041

---

When are we going to use truncate and delete?

984

---

what is the difference between delete and truncate commands? : Sql dba

1067

---

How do you update f as m and m as f from the below table testtable?

1852

---

What does where 1/2 mean in sql?

1064

---

What is set transaction?

1035

---

What is sql dialect?

1112

---

What is sql used for?

1122

---

Does a user_objects view have an entry for a trigger?

1008

---

What does (*) mean in sql?

948

---

How do you copy a table in sql?

1066

---

What is the difference between count 1 and count (*) in a sql query?

987

---