A table join to itself is known as self join. select emp.ename,mng

What is a self join? Explain it with an example?

Question Posted / mona

16 Answers
61701 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / mona

A table join to itself is known as self join.

select emp.ename,mngr.ename from emp.empl,emp.mngr where
emp.mngrno=mngr.empno

Is This Answer Correct ?

15 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2104

Explain about the relational database?

1130

Explain the process of the user request and data generating?

1144

What is dbms explain in brief?

1084

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2186

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4053

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2210

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2470

Explain the rollup operator?

1143

How long can an error message be in raiseerror function?

1045

Explain about the database management systems.

1027

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1023

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1051

What is a database development?

1015

How to combine two function together?

2202