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)

How do I run a pl sql procedure in sql developer?

968

---

Why sql query is slow?

987

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

997

---

What is sql integrity?

1147

---

What is difference between sql and excel?

1087

---

What is nvarchar in sql?

924

---

what are the security recommendations while using mysql? : Sql dba

1112

---

What is the difference between inner join and left join?

984

---

What are the various restrictions imposed on view in terms of dml?

963

---

What is use of trigger?

928

---

How to pronounce postgresql?

1055

---

What are the types of index in sql?

1065

---

Is sql easier than java?

1004

---

What are primary key and foreign key and how they work?

973

---

I need a function for a train ticket reservation please answer it thanks in advance

1023

---