Answer Posted / ajit

select e.*, rn
from ( select empno, ename, sal, deptno, dense_rank() over ( order by sal desc ) rn
from emp) e
where rn = & rn;

Is sqlite good enough for production?

1045

---

Why is pl sql needed?

1004

---

Define overloaded procedure?

1130

---

What is dynamic query?

1034

---

What is the difference between stored procedure and view?

1064

---

Is sql database free?

1024

---

What is a memo field?

1015

---

What are sql functions? Describe in brief different types of sql functions?

1179

---

Why functions are used in sql?

1041

---

How do I start sql profiler?

1047

---

what are the differences between char and nchar? : Sql dba

1160

---

how to use like conditions? : Sql dba

1164

---

What is join view in sql?

988

---

Explain character-manipulation functions?

1174

---

Why use triggers in sql?

1011

---