Answer Posted / ayush

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

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1163

---

What is faster join or subquery?

1066

---

what is self join and what is the requirement of self join? : Sql dba

1191

---

What is sql character function?

1151

---

What are sql injection vulnerabilities?

1027

---

What is schema in sql example?

1278

---

what does it mean to have quoted_identifier on? : Sql dba

1181

---

How to change sql*plus system settings?

1110

---

how do you control the max size of a heap table? : Sql dba

1025

---

Why is the cursor important?

1079

---

What are types of joins?

1028

---

What does data normalization mean?

1028

---

What is pivot in sql?

973

---

What is break?

1256

---

How to get unique records from a table?

1022

---