Answer Posted / satya

Hi,

Select sal from emp e where 3>=(select count (Sal)
from emp where sal>e.sal) order by sal desc;

Regards,
Satya.k

How does postgresql compare to mysql?

1020

---

What is pivot in sql?

903

---

How do sql triggers work?

1024

---

What are two statement types in sql?

1067

---

Can primary key be changed?

896

---

How do I view tables in sql developer?

927

---

What is union?

1143

---

How to sort the rows in sql.

1052

---

What is the difference between join and natural join?

919

---

What does the file extension accdb stand for?

961

---

Explain polymorphism in pl/sql.

1102

---

What does trigger mean in slang?

1036

---

Can we insert in view in sql?

1039

---

how to use in conditions? : Sql dba

994

---

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

2003

---