StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POA problem with getting the correct data
primarykey
Id
7455644
data
AcceptedAnswerId
7456833
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-09-17T14:58:23.480
FavoriteCount
0
LastActivityDate
2011-09-17T19:17:37.737
LastEditDate
2011-09-17T16:15:42.560
LastEditorUserId
770022
OwnerUserId
770022
ParentId
0
PostTypeId
1
Score
0
ViewCount
229
LastEditorDisplayName
text
Body
I have created a query that looks like this but I havent found a way to group the departments together. Thats the part I need help with. I want to get Department number in one colum, Employee is another and then the person that would be their colleague in another. Any help would be great. This is what I want it to look like <pre><code> DEPARTMENT EMPLOYEE COLLEAGUE 10 CLARK KING 10 CLARK MILLER 10 KING CLARK 10 KING MILLER 10 MILLER CLARK 10 MILLER KING 20 ADAMS FORD 20 ADAMS JONES 20 ADAMS SCOTT 20 ADAMS SMITH </code></pre> And here is what I got so far but is not correct.Kings colleague is not King its Clark and Miller. Clarks colleague is not Clark its king and Miller. <pre><code> SQL> select ename AS Employee, deptno AS Department, ename AS Colleague from emp order by deptno asc; EMPLOYEE DEPARTMENT COLLEAGUE ---------- ---------- ---------- KING 10 KING CLARK 10 CLARK MILLER 10 MILLER ADAMS 20 ADAMS SCOTT 20 SCOTT SMITH 20 SMITH FORD 20 FORD JONES 20 JONES WARD 30 WARD JAMES 30 JAMES ALLEN 30 ALLEN EMPLOYEE DEPARTMENT COLLEAGUE ---------- ---------- ---------- MARTIN 30 MARTIN BLAKE 30 BLAKE TURNER 30 TURNER 14 rows selected. </code></pre> Heres the dept table <pre><code> SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON </code></pre> Heres the emp table <pre><code> SQL> select ename, deptno, job from emp; ENAME DEPTNO JOB ---------- ---------- --------- KING 10 PRESIDENT BLAKE 30 MANAGER CLARK 10 MANAGER JONES 20 MANAGER MARTIN 30 SALESMAN ALLEN 30 SALESMAN TURNER 30 SALESMAN JAMES 30 CLERK WARD 30 SALESMAN FORD 20 ANALYST SMITH 20 CLERK ENAME DEPTNO JOB ---------- ---------- --------- SCOTT 20 ANALYST ADAMS 20 CLERK MILLER 10 CLERK 14 rows selected. </code></pre>
Tags
<sql><oracle><oracle10g><sqlplus>
Title
A problem with getting the correct data
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser770022
UserOwnerUserId
1. USuser770022
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.