Answer Posted / kavitha nedigunta

select a.ename,a.sal
from(select ename,sal,
dense_rank() over( order by sal desc nulls last) rk
from emp)a
where rk =5;

What sql database should I use?

790

---

What does joining a thread mean?

753

---

how would concatenate strings in mysql? : Sql dba

742

---

Explain spool.

906

---

What are joins in sql?

719

---

---

Is keyword pl sql?

732

---

What is meant by truncate in sql?

754

---

What is cursor explain with example?

735

---

When can we use the where clause and the having clause?

780

---

Is primary key always clustered index?

733

---

Does truncate need commit?

699

---

How do you drop a trigger?

713

---

What are the parts of a sql statement?

767

---

What are sql injection vulnerabilities?

692

---

What are records give examples?

745

---