Answer Posted / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

What is dynamic sql in pl sql?

507

---

What are actual parameters and formal parameters?

581

---

How does pl sql work?

534

---

What is group by in sql?

558

---

How to change the order of columns in Oracle SQL Plus ?

622

---

---

what is the difference between join and union? : Sql dba

558

---

What are different joins used in sql?

560

---

What is a trigger in sql?

646

---

What is the largest value that can be stored in a byte data field?

525

---

What is data type in database?

558

---

What is an implicit commit?

565

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

788

---

Can we enter data in a table in design view?

526

---

Is a secondary key the same as a foreign key?

500

---

What is foreign key in sql with example?

523

---