Answer Posted / ayush

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

What is embedded sql what are its advantages?

1035

---

what is uncommittable transactions? : Transact sql

996

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2014

---

What is the difference between inner join and outer join?

992

---

What are the three forms of normalization?

1045

---

What is Collation Sensitivity ? What are the various type ?

952

---

What is sql stand for?

980

---

What is data manipulation language?

1187

---

What is a table partition?

1125

---

What is the difference between inner join and left join?

985

---

How to write pl sql program in mysql command prompt?

1089

---

How does an execution block start and end in pl sql?

950

---

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

1155

---

What are sql injection vulnerabilities?

981

---

How many sql databases can you have on one server?

1081

---