Answer Posted / amar_kondla

select * from emp----- is a query;


and

co-related query is sub one of sub qury( sub qury
means--whose returning values are filtering the condition
of the main query)
ex; SELECT * FROM EMP E
WHERE E.SAL>( SELECT AVG(SAL) FROM EMP F
WHERE E.DEPTNO= F.DEPTNO);


SO HERE WE R FINDING THE EMPLOYEE WHO HAS GETTING MORE THAN
AVG(SAL) OF RESPECTING DEPTNO.

AND CO RELATED SUB QUERY ALWAYS USE ALIAS NAME FOR TABLE, IT
SIMILAR LIKE JAIN(SELF JOIN)

What are the 3 modes of parameter?

1156

---

Explain mutating table error.

1212

---

What is db journal file?

1071

---

Why do we use triggers?

974

---

What is sql dialect?

1124

---

What is embedded sql what are its advantages?

1045

---

Is there any restriction on the use of union in embedded sql?

1161

---

What are different types of statements supported by sql?

1165

---

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

969

---

What is the difference between inner join and natural join?

1012

---

What is the difference between view and stored procedure?

962

---

What is break?

1203

---

What is the use of function "module procedure" in pl/sql?

1200

---

what is timestamp in mysql? : Sql dba

1081

---

How do I run a sql trace?

963

---