Answer Posted / jeevitha

select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n

Can we use insert statement in function?

964

---

Which sorts rows in sql?

985

---

What is pivot table in sql?

1046

---

Write a unique difference between a function and a stored procedure.

950

---

What is a database event trigger?

1107

---

What is trigger point?

965

---

What is asqueryable?

913

---

how to present a past time in hours, minutes and seconds? : Sql dba

966

---

Explain alias in sql?

1009

---

What is the function that is used to transfer a pl/sql table log to a database table?

974

---

What is pl sql collection?

931

---

How does a covering index work?

926

---

What is the process of copying data from table a to table b?

1062

---

Is pl sql different from sql?

951

---

How do I start sql profiler?

958

---