Answer Posted / shiva

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

Is full outer join same as cross join?

969

---

What is sql and how does it work?

1173

---

describe mysql connection using mysql binary. : Sql dba

1066

---

What is the need of a partition key?

987

---

What is varchar data type in sql?

1082

---

what is error ora-03113: end-of-file on communication channel?

1165

---

What are some emotional triggers?

985

---

What are types of indexes in sql?

1082

---

explain mysql aggregate functions. : Sql dba

989

---

How to check if a column is nullable before setting to nullable?

1126

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

---

Where is sql database stored?

981

---

Can we use views in stored procedure?

1031

---

what are myisam tables? : Sql dba

1032

---

Explain ddl statements in pl/sql?

1009

---