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

What are sql functions? Describe in brief different types of sql functions?

1104

---

What is the use of %rowtype?

1041

---

What is cursor and its types?

1073

---

Is there any restriction on the use of union in embedded sql?

1157

---

What is sql profiling in oracle?

1065

---

What is the difference between view and stored procedure?

959

---

What is the size of partition table?

1048

---

Is sql injection illegal?

1025

---

how to fetch common records from two tables? : Sql dba

1172

---

what is a tablespace? : Sql dba

1053

---

What is the cause of mutating table error and how can we solve it?

1049

---

what are the 'mysql' command line arguments? : Sql dba

1139

---

How to return multiple rows from the stored procedure?

970

---

Is it possible to read/write files to-and-from PL/SQL?

1103

---

What are the dml statements?

1143

---