Answer / srinu

Joining the Table data it self is called self join,it will work based on the join condition

Answer / alok kumar samartha

The concept of joining a table with itself is called self
join or inner join.It works based on the provided join condition
example:-select e1.empno employee,e2.ename manager from emp
e1,emp e2 where e2.empno=e1.mgr;

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

What are string functions in sql?

0 Answers  

---

What is the use of %rowtype?

0 Answers  

---

What are the types of dbms?

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

What is sql and explain its components?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

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

0 Answers  

---

what is normalization? : Sql dba

0 Answers  

---

Compare sql & pl/sql

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---