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 sql*plus environment variables?

1030

---

What is an implicit commit?

990

---

How many types of sql are there?

929

---

Mention what are different methods to trace the pl/sql code?

1103

---

What is sql prepared statement?

937

---

Differentiate pl/sql and sql?

1011

---

What are the popular database management systems in the it industry?

925

---

What is the difference between the implicit and explicit cursors?

993

---

Can we use pl sql in sql server?

1012

---

What is query syntax?

913

---

Why is sql better than hql?

920

---

How to get list of all tables from a database?

1107

---

how to include numeric values in sql statements? : Sql dba

1039

---

What is primary key secondary key alternate key candidate key?

980

---

What is the difference between count 1 and count (*) in a sql query?

908

---