Answer Posted / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Which is faster count (*) or count 1?

1014

---

What does count (*) do in sql?

991

---

Can you call pl/sql package functions from within a fast formula?

1025

---

What are some predefined exceptions in pl/sql?

1147

---

What are different types of functions in sql?

993

---

Explain aggregate functions are available there in sql?

983

---

What is the difference between an inner and outer join?

1001

---

What will you get by the cursor attribute sql%rowcount?

1020

---

Is sql better than excel?

1122

---

What is cross join example?

975

---

Can we rollback truncate?

988

---

What is exit statement?

1005

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

979

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1025

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

944

---