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;

What is the difference between sum and count in sql?

938

---

What are all ddl commands?

1015

---

How do you concatenate in sql?

975

---

What is offset in sql query?

1073

---

Is sql scripting language?

975

---

Why should I use postgresql?

973

---

Is sqlite thread safe?

993

---

How do you clear the screen in sql?

1012

---

Why procedure is used in sql?

977

---

what are date and time functions in mysql? : Sql dba

927

---

Is merge a dml statement?

924

---

Define implicit and explicit cursors.

1076

---

Why commit is not used in triggers?

994

---

What's the difference between a primary key and a clustered index?

947

---

How do you determine the current isolation level? : Transact sql

1075

---