Answer Posted / shiva

select e.* from emp e where e.sal>(select avg(sal) from emp);

what is the bond code in materialized view?

2583

---

describe mysql connection using mysql binary. : Sql dba

644

---

What is the use of function in sql?

647

---

How can we store rows in PL/SQL using array?

766

---

Does view store data in sql?

611

---

---

What is the advantage of index in sql?

617

---

What is t sql used for?

629

---

What is the usage of distinct keyword?

714

---

How insert into statements in sql?

691

---

Are pl sql variables case sensitive?

695

---

What is the current version of postgresql?

631

---

How many row comparison operators are used while working with a subquery?

643

---

What are its different types of dbms?

624

---

how to calculate the difference between two dates? : Sql dba

641

---

what is the use of friend function? : Sql dba

629

---