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 is difference between stored procedures and application procedures?

994

---

Why is a primary key important?

1024

---

What is faster join or subquery?

994

---

Can we use pl sql in mysql?

994

---

What is benefit of creating memory optimized table?

954

---

Can we perform dml on view?

1028

---

What is an oracle stored procedure?

1028

---

What are the disadvantages of file system?

1236

---

how can we know the count/number of elements of an array? : Sql dba

1043

---

Is left join faster than inner join?

1103

---

How can you fetch common records from two tables?

1045

---

Which one is better sql or oracle?

949

---

what are date and time functions in mysql? : Sql dba

963

---

how to convert character strings to numeric values? : Sql dba

1077

---

Can a select statement fire a trigger?

1136

---