Answer Posted / rishab

select emp_name,salary,rownum from
(select emp_name,salary,r from
(select salary,emp_name,rownum r from
(select salary,emp_name,rownum
from emp
order by salary desc)
order by r)
where r<4 ---- this number must be n+1
order by salary)
where rownum=1;
-- yes rownum=1 works...

Describe different types of general function used in sql?

530

---

what is not null constraint? : Sql dba

544

---

Is the primary key an index?

594

---

Why having clause is used in sql?

536

---

Where do we use pl sql?

549

---

---

What is difference between hql and native sql?

576

---

How do I debug a stored procedure?

625

---

Explain select statements in sql?

584

---

What is dynamic query?

539

---

State some properties of relational databases?

580

---

Is sql pronounced sequel or sql?

736

---

Define SQL and state the differences between SQL and other conventional programming Languages?

679

---

What are records give examples?

560

---

how to decrement dates by 1 in mysql? : Sql dba

581

---

Why we use joins in sql?

536

---