Answer Posted / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

what is blob? : Sql dba

564

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

648

---

What does trigger mean in slang?

531

---

What are the features of pl sql?

565

---

What is the mutating table and constraining table?

563

---

---

What is orm in sql?

541

---

How can I tell if sql is running?

593

---

What is the non-clustered index in sql?

591

---

Can a varchar be a primary key?

540

---

what are properties of a transaction? : Sql dba

562

---

Is ms sql traffic encrypted?

505

---

What is the difference between union and union all command?

556

---

how to install mysql? : Sql dba

582

---

What is sql deadlock?

567

---

What is duration in sql profiler trace?

557

---