This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hello i have the following table having EMP BOSS SALARY --------------- --------------- ---------- Albert NULL 1000 Bert Albert 900 Chuck Albert 900 Donna Chuck 800 Eddie Chuck 700 Fred Chuck 600 Faisal Fred 400
it create a tree structure , and i want to write select statement to get all employees whose boss is chuck like donna , eddie, fred and faisal too, bcs fred boss is also Chuck please help me in solving the problem Faisal
Faisal, You are going to need more than one query. First, you get all the employees whose direct boss is Chuck. Then, you get the employees that have a boss that was returned by your first query. Repeat until your queries don't return any results.