Answer Posted / 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;

Can a primary key be a foreign key?

1022

---

What are the methods of filing?

935

---

Write an sql query to select all records from the table?

1028

---

What is embedded sql in db2?

1017

---

What is integrity in sql?

1045

---

how to increment dates by 1 in mysql? : Sql dba

978

---

how to select unique records from a table? : Sql dba

1112

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2497

---

What is online transaction processing (oltp)?

1017

---

What are the benefits of pl sql?

1121

---

What is the usage of distinct keyword?

1067

---

how to return query output in html format? : Sql dba

1073

---

What is audit logout in sql profiler?

1024

---

How many sql statements are used?

1010

---

How do I order columns in sql?

1007

---