Answer Posted / ayush

select *
from (select ename,empno,salary,dense_rank()over(order by
salary desc) rank from emp)
where rank =2

how to rename an existing table in mysql? : Sql dba

1069

---

What is the difference between delete and truncate commands?

1050

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1166

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1045

---

explain normalization concept? : Sql dba

1053

---

Should I use mbr or gpt?

1033

---

What jobs use sql?

987

---

what is “go” in t-sql? : Transact sql

1117

---

What are procedures used for?

992

---

What is pl sql package?

1041

---

What is scalar function?

1058

---

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

1164

---

Why we use pl sql?

968

---

What is query optimization in sql?

990

---

What has stored procedures in sql?

1070

---