Answer Posted / kavitha nedigunta

b. select/from/table_name/groupby/having/orderby

EG: select deptno,max(sal)
from emp
group by deptno
having max(sal)> 5000
order by deptno

what is view? : Sql dba

554

---

Explain commit, rollback and savepoint.

598

---

what is a join? : Sql dba

559

---

How can I speed up sql query?

520

---

What is a table?

563

---

---

Are left and right joins the same?

525

---

give the syntax of grant and revoke commands? : Sql dba

607

---

What are local and global variables and their differences?

580

---

How do you rank data in sql?

511

---

What do you mean by query optimization?

541

---

How does index help in query performance?

556

---

Explain the working of foreign key?

539

---

What is the difference between rename and alias?

699

---

What are types of exception?

530

---

Explain two easy sql optimizations.

598

---