Sunday, April 16, 2006

SECTION 3 LESSON 5
1. Display the employee's last name and employee number along with the manager's last name and manager number. Label the columns:Employee, Emp#, Manager, and Mgr#, respectively. -

---select e.last_name "Employee",e.employee_id "Emp #",m.manager_id "Mgr #",m.last_name "Manager"
from employees e,employees m
where e.employee_id=m.manager_id

2. Modify question 1 to display all employees and their managers, even if the employee does not have a manager. Order the list alphabetically by the last name of the employee.

----select e.last_name "Employee",e.employee_id "Emp #",m.manager_id "Mgr #",m.last_name "Manager"
from employees e,employees

where e.employee_id(+)=m.manager_id
order by e.last_name;

3. Display the names and hire dates for all employees who were hired before their managers, along with their managers' names and hire dates. Label the columns Employee, Emp Hired, Manager, and Mgr Hired, respectively
d
---- select e.first_name' 'e.last_name "Employee",e.hire_date "Emp Hire",m.first_name' 'm.last_name "Manager",m.hire_date "Mgr Hire"
from employees e,employees m
where e.manager_id=m.employee_id and e.hire_date

4. Finish this code to produce all possible combinations of rows from both tables:
SELECT e.last_name, e.department_id, d.department_name

----SELECT e.last_name, e.department_id, d.department_name
from employees e,departments d
where e.department_id=d.department_id;

5. Finish this code to produce all information in the departments table whether it has a match in the locations table or not:
SELECT l.location_id, l.city, d.department_name

----SELECT l.location_id, l.city, d.department_name
from locations l,departments d
where l.location_id=d.department_id;

6. Finish this code to produce the following information for Diana Lorentz:
SELECT e.last_name, d.department_name

----select e.last_name,d.department_name
from employees e,departments d
where e.last_name='Diana', e.first_name='Lorentz'
and e.department_id=d.department_id;

7. How do you know which side of a join gets the (+) sign?
----This side has the values that the other doesn't.

79 Comments:

Blogger Daniel Joseph said...

SAP stands for Systems Applications and Products in Data Processing. SAP is one of the leading ERP software in the world. SAP has been widely used by large to very large organizations and also by SMEs to manage their business processes.
Sap training in chennai | SAP Success factor training in chennai | Workday training in chennai | Success factor training in chennai

11:53 PM  
Blogger glennparyy said...

Oracle ADG is well known. But this HW is not known well about all.

Java training in Chennai | Android training in chennai | IOS training in chennai

4:19 AM  
Blogger joshnson haddin said...

Essentially hadoop training in chennai pushing back to blog is basic now a daysoracle training in chennai. In the meantime you have made my classes clear in all viewpoints oracle dba training in chennaisuch that I can proceed further.

12:52 AM  
Blogger joshnson haddin said...

Basically oracle training in chennai pushing back to blog is essential now a days.oracle dba training in chennai Meanwhile you have made my classes clear in all perspectives such that I can hadoop training in chennai continue further.

12:55 AM  
Blogger Stephen said...

There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this. FITA chennai reviews

12:03 AM  
Blogger Isha Gupta said...


Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
Greens Technologies Training In Chennai

11:40 AM  
Blogger Isha Gupta said...


This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this,
I feel happy about it and I love learning more about this topic
Greens Technologies Training In Chennai

11:40 AM  
Blogger Isha Gupta said...

Thanks for sharing this informative blog. I did SAS Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..
SAS Training In Chennai

11:41 AM  
Blogger Isha Gupta said...


Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it,
because you have explained the concepts very well. It was crystal clear, keep sharing..
QTP Training In Chennai

11:42 AM  
Blogger Isha Gupta said...


There are lots of information about latest technology and how to get trained in them, like Hadoop Training in Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..
Hadoop Training In Chennai

11:42 AM  
Blogger Isha Gupta said...

This post is really nice and informative. The explanation given is really comprehensive and informative..
Pega Training In Chennai

11:43 AM  
Blogger Isha Gupta said...


Thanks for sharing such a great information..Its really nice and informative..
Informatica Training In Chennai

11:43 AM  
Blogger Isha Gupta said...


Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..
Oracle Training In Chennai

11:44 AM  
Blogger Isha Gupta said...


I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
Oracle Training In Chennai

11:44 AM  
Blogger Revathi S said...

Thanks for sharing amazing information about pega Gain the knowledge and hands-on experience you need to successfully design, build and deploy applications with pega. Pega Training in Chennai

2:56 AM  
Blogger Revathi S said...

Who wants to learn Informatica with real-time corporate professionals. We are providing practical oriented best Informatica training institute in Chennai. Informatica Training in chennai

2:57 AM  
Blogger Revathi S said...

QTP is a software Testing Tool which helps in Functional and Regression testing of an application. If you are interested in QTP training, our real time working. QTP Training in Chennai

2:57 AM  
Blogger Revathi S said...

Looking for real-time training institue.Get details now may if share this link visit Oracle Training in chennai

2:58 AM  
Blogger Revathi S said...

Hey, nice site you have here!We provide world-class Oracle certification and placement training course as i wondered Keep up the excellent work experience!Please visit Greens Technologies located at Chennai Adyar Oracle Training in chennai

2:58 AM  
Blogger Revathi S said...

Awesome blog if our training additional way as an SQL and PL/SQL trained as individual, you will be able to understand other applications more quickly and continue to build your skill set which will assist you in getting hi-tech industry jobs as possible in future courese of action..visit this blog Green Technologies In Chennai

2:58 AM  
Blogger Revathi S said...

Nice site....Please refer this site also Our vision succes!Training are focused on perfect improvement of technical skills for Freshers and working professional. Our Training classes are sure to help the trainee with COMPLETE PRACTICAL TRAINING and Realtime methodologies. Green Technologies In Chennai

2:59 AM  
Blogger Revathi S said...

if share valuable information about hadoop training courses, certification, online resources, and private training for Developers, Administrators, and Data Analysts may visit Hadoop Training in Chennai

2:59 AM  
Blogger Revathi S said...

let's Jump Start Your Career & Get Ahead. Choose sas training method that works for you. This course is designed for professionals looking to move to a role as a business analyst, and students looking to pursue business analytics as a career. SAS Training in Chennai

3:00 AM  
Blogger harithasri said...

Greens Technology offer a wide range of training from ASP.NET , SharePoint, Cognos, OBIEE, Websphere, Oracle, DataStage, Datawarehousing, Tibco, SAS, Sap- all Modules, Database Administration, Java and Core Java, C#, VB.NET, SQL Server and Informatica, Bigdata, Unix Shell, Perl scripting, SalesForce , RedHat Linux and Many more.

4:20 AM  
Blogger harithasri said...

Greens Technologies Training In Chennai Excellent information with unique content and it is very useful to know about the information based on blogs.

4:22 AM  
Blogger harithasri said...

Thanks for sharing this nice useful informative post to our knowledge, Actually SAS used in many companies for their day to day business activities it has great scope in future.

4:25 AM  
Blogger harithasri said...

Our HP Quick Test Professional course includes basic to advanced level and our QTP course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the QTP certification training course.

4:26 AM  
Blogger harithasri said...

A Best Pega Training course that is exclusively designed with Basics through Advanced Pega Concepts.With our Pega Training in Chennai you’ll learn concepts in expert level with practical manner.We help the trainees with guidance for Pega System Architect Certification and also provide guidance to get placed in Pega jobs in the industry.

4:27 AM  
Blogger harithasri said...

Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.Informatica Training In Chennai

4:28 AM  
Blogger harithasri said...

There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.

4:29 AM  
Blogger harithasri said...

Oracle Training in Chennai is one of the best oracle training institute in Chennai which offers complete Oracle training in Chennai by well experienced Oracle Consultants having more than 12+ years of IT experience.

4:30 AM  
Blogger harithasri said...

It is really very helpful for us and I have gathered some important information from this blog.
Oracle Training In Chennai

4:31 AM  
Blogger Ravindra Reddy said...

Very nice articles,thanks for sharing.

SAP XI Training

OBIEE Training

Talend Training

PHP Training

12:44 AM  
Blogger Pooja Doss said...

Oracle DBA Training in Chennai
Thanks for sharing this informative blog. I did Oracle DBA Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..

4:37 AM  
Blogger Pooja Doss said...

Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
Websphere Training in Chennai

4:37 AM  
Blogger Pooja Doss said...

Data warehousing Training in Chennai
I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..

4:37 AM  
Blogger Pooja Doss said...

Selenium Training in Chennai
Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

4:38 AM  
Blogger Pooja Doss said...

Oracle Training in chennai
Thanks for sharing such a great information..Its really nice and informative..

4:39 AM  
Blogger Pooja Doss said...

SAP Training in Chennai
This post is really nice and informative. The explanation given is really comprehensive and informative..

4:39 AM  
Blogger Pooja Doss said...

This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..
Android Training In Chennai In Chennai

4:40 AM  
Blogger Pooja Doss said...

Pretty article! I found some useful information in your blog, it was awesome to read,thanks for sharing this great content to my vision, keep sharing..
Unix Training In Chennai

4:40 AM  
Blogger Pooja Doss said...

I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
SalesForce Training in Chennai

4:40 AM  
Blogger Pooja Doss said...

There are lots of information about latest technology and how to get trained in them, like Best Hadoop Training In Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..

4:41 AM  
Blogger Saranya D said...

have to learned to lot of information about java Gain the knowledge and hands-on experience you need to successfully design, build and deploy applications with java.
Java Training in Chennai

11:22 PM  
Blogger Saranya D said...


Looking for real-time training institue.Get details now may if share this link visit
Spring Training in chennai
oraclechennai.in:

11:22 PM  
Blogger Saranya D said...

Hybernet is a framework Tool. If you are interested in hybernet training, our real time working.
Hibernate Training in Chennai.
hibernate-training-institute-center-in-chennai

11:22 PM  
Blogger Saranya D said...

Awesome blog if our training additional way as an SQL and PL/SQL trained as individual, you will be able to understand other applications more quickly and continue to build your skill set which will assist you in getting hi-tech industry jobs as possible in future courese of action..visit this blog
plsql in Chennai
greenstechnologies.in:

11:22 PM  
Blogger Saranya D said...


Job oriented form_reports training in Chennai is offered by our institue is mainly focused on real time and industry oriented. We provide training from beginner’s level to advanced level techniques thought by our experts.
forms-reports Training in Chennai

11:23 PM  
Blogger Raju Kumar said...

nice post and site, good work! This article is well written and quite informative. More articles should be written and you have just found a follower.and more visit
sas online training

1:10 AM  
Blogger Diya Patel said...

This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..
Informatica Training in chennai | QTP Training in Chennai



4:54 AM  
Blogger Santhiya said...

Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
QTP Training in Chennai

3:54 AM  
Blogger Santhiya said...

I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
selenium training in chennai


11:13 PM  
Blogger Santhiya said...


Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
QTP Training in Chennai



11:13 PM  
Blogger Harini said...

Excellent information with unique content and it is very useful to know about the
information based on blogs.
Selenium Training in Chennai | QTP Training In Chennai

5:09 AM  
Blogger Dinju Thomas said...

Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
Selenium Training In Chennai | QTP Training In Chennai

12:04 AM  
Blogger Dinju Thomas said...

Thanks for Information Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business
Oracle Apps Training In Chennai | Oracle D2K Training In Chennai

12:04 AM  
Blogger Dinju Thomas said...

Oracle Training In Chennai
This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

12:05 AM  
Blogger Rashmi D'souza said...

I am very impressed with the article I have just read,so nice.......
Manual Testing Training in Chennai

4:31 AM  
Blogger Akasha said...

very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our

vision. You have posted a trust worthy blog keep sharing.
sap abap Training in Chennai

11:46 PM  
Blogger Akula Rahul said...

Latest Indian Govt Jobs 2016 Notification

Thanks so much for the article post.Really thank you! Will read on…..........

3:11 AM  
Blogger Ramya Kolluru said...

Assam 2564 Police Constable Recruitment 2016


I appreciate you sharing this blog article.Thanks Again. Want more....................

4:04 AM  
Blogger for IT the said...

Great Article
Online Java Training | Java EE course | Java Course in Chennai | Java Training in Chennai | Java Training Institutes in Chennai | J2EE Training in Chennai | java j2ee training institutes in chennai

9:38 AM  
Blogger Mervin Parmar said...

Using big data analytics may give the companies many fruitful results, the findings can be implemented in their business decisions so as to minimize their risk and to cut the costs.
hadoop training in chennai|big data training|big data training in chennai

4:04 AM  
Blogger Raghu Sharma said...

Cloud computing is the next big thing, through cloud the users have the liberty to use a shared network. The companies can focus on core business parts rather than investing heavily on infrastucture.
cloud computing training in chennai|cloud computing courses in chennai|cloud computing training

4:06 AM  
Blogger Savitha said...

Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
Informatica Training In Chennai
Hadoop Training In Chennai
Oracle Training In Chennai
SAS Training In Chennai

10:05 PM  
Blogger Harini said...

This post is really nice and informative. The explanation given is really comprehensive and informative..
SAS Training In Chennai

4:25 AM  
Blogger Diya Patel said...

Best SQL Query Tuning Training Center In Chennai This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

12:14 AM  
Blogger Abina Ragav said...

iOS training in chennai THINKIT is a leading iOS training institute in Chennai, India. We offer various professional and job oriented courses to students, fresher, job seekers and professionals. Our courses include.Apart from regular training to students and experienced professionals, we also provide completely customized training's to entrepreneurs, small business owners and startup companies.

5:53 AM  
Blogger Abina Ragav said...


Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us... JAVA Training in chennai

6:08 AM  
Blogger Ridhima said...


All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates…
Regards

Hadoop Training in Chennai

10:45 PM  
Blogger Ridhima said...

Everything is fine, am happy about your blog. Thanks admin for sharing the unique content, you have done a great job I appreciate your effort and I hope you will get more positive comments from the web users.
Regards,

Hadoop Training in Chennai

10:47 PM  
Blogger Ridhima said...

Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates.

Hadoop Training in Chennai

10:50 PM  
Blogger Mervin Parmar said...

Big data is used extensively in MNC today as using big data leads to accurate decision making and there are is a huge demand for the big data analysts.
Big data training in Chennai | Hadoop training in Chennai | Big data training institute in Chennai

4:31 AM  
Blogger Arjun kumar said...

This comment has been removed by the author.

6:05 AM  
Blogger Arjun kumar said...

Excellent article. Hadoop is a cloud based tool.It give more information about massive storage and it helps to improve our skills. Hadoop provides more job opportunities.To achieve a great career join with us.Hadoop Training Chennai|Big Data Training Chennai
Regards,
Arjun

11:55 PM  
Blogger Chinni Bocha said...

nice content of blog..SEO Best training in hyderabad.Who looking for better future and goals to have good education this will be the perfect seo training center.
Best SEO training in hyderabad

10:15 PM  
Blogger Training Coimbatore said...

great post

Hadoop training in coimbatore
Java training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore

6:31 AM  
Blogger Rakesh S said...


Hadoop online training .All the basic and get the full knowledge of hadoop.
hadoop online training

2:21 AM  
Blogger Rohit P said...

digital marketing training in bangalore
seo training in bangalore

12:22 AM  

Post a Comment

<< Home