Answer Posted / venkateswarulu.s

select min(salary) from emp where salary in(select distinct
top 3 salary from
emp order by salary desc)

Explian rowid, rownum?

566

---

How do rank () and dense_rank () differ?

524

---

What is the difference between database trigger and stored procedure?

559

---

What is the difference between function and procedure in pl/sql?

546

---

What is synchronized subquery?

601

---

---

What is sqlservr exe?

482

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

554

---

How do I access sql anywhere database?

501

---

What is mutating error in pl sql?

553

---

Does pl sql work in mysql?

538

---

What is sql select statement?

509

---

How can get second highest salary in sql?

509

---

What happens when a trigger is associated to a view?

506

---

What are two statement types in sql?

540

---

What are the methods of filing?

524

---