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

Can we join two tables without common column?

1002

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

1029

---

Explain ttitle and btitle.

1118

---

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

968

---

how to convert character strings to dates? : Sql dba

1060

---

what is unique key constraint? : Sql dba

1035

---

Does truncate remove indexes?

1033

---

What is #table in sql?

1098

---

how can we find the number of rows in a table using mysql? : Sql dba

1083

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1065

---

Can you sum a count in sql?

1011

---

What is execution plan in sql?

1046

---

What is sqlerrm?

935

---

How can check sql version from command line?

1085

---

What is embedded sql what are its advantages?

1043

---