Answer Posted / selvaspak

select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank = &no

Actually for this Question there are having lot of method
to get the result, but the interviewer is asking this for
to check whether the interview person know the RANK()
function or not. So the above query is correct

What is cursor and its types?

1026

---

What is not null in sql?

1007

---

What are the advantages of pl sql?

1092

---

What is number function in sql?

934

---

How do you explain an index?

1243

---

How global cursor can be declare with dynamic trigger ?

2165

---

Does mysql_real_escape_string prevent sql injection?

925

---

Explain commit, rollback and savepoint.

958

---

what is auto increment? : Sql dba

980

---

Name the operator which is used in the query for pattern matching?

916

---

What is the sql case statement?

974

---

What will you get by the cursor attribute sql%found?

936

---

Explain ddl statements in pl/sql?

979

---

What does pl sql developer do?

901

---

What is tuple in sql?

1029

---