Answer Posted / swapna

select ename from emp where sal>(select avg(sal) from emp);

what are the different type of sql's statements ? : Sql dba

979

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

---

Explain scalar functions in sql?

1105

---

Can you have more than one key in a database?

993

---

How do rank () and dense_rank () differ?

1109

---

What does dml mean?

1043

---

What is time based sql injection?

1035

---

Why sql query is slow?

1044

---

how to get @@error and @@rowcount at the same time? : Sql dba

1082

---

Is vs as in pl sql?

1037

---

What is clause in sql?

1178

---

Is sql a backend language?

1145

---

What is the difference between truncate and drop statements?

1261

---

Can %notfound return null after a fetch?

1102

---