Answer Posted / manish

select * from emp; --->> query

select * from emp where sal=(select max(sal) from emp);
--> here a sub query is also there

select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query

Which normal form is best?

513

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

576

---

Can we insert data in view?

501

---

What does where 1/2 mean in sql?

528

---

Advantages and disadvantages of stored procedure?

578

---

---

How do I kill a query in postgresql?

552

---

Why schema is used in sql?

515

---

What is union and union all keyword in sql?

565

---

What is file based approach?

487

---

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

547

---

How to select 10 records from a table?

644

---

Why we use triggers in mysql?

557

---

What is the difference between rename and alias?

706

---

What do you mean by field in sql?

534

---

Which is better join or subquery?

604

---