Answer Posted / srikanth

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

Can you have a foreign key without a primary key?

963

---

define join and explain different type of joins? : Sql dba

958

---

What does stand for in sql?

982

---

What is substitution variable?

1061

---

How can we avoid duplicating records in a query?

991

---

How do I edit a trigger in sql developer?

1006

---

what is a constraint? Tell me about its various levels. : Sql dba

1000

---

What are the differences between in and exists clause?

1124

---

what tools available for managing mysql server? : Sql dba

1093

---

explain advantages of innodb over myisam. : Sql dba

1138

---

What is the use of nvl function?

1209

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031

---

What is cartesian join in sql?

1141

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1041

---

How many times can we commit in a loop?

1029

---