Solved

selecting distinct values - oracle 10 sql syntax

Posted on 2011-03-14
3
241 Views
Last Modified: 2012-08-13
Please see the attachment.

fig 1. Is the current output.
fig 2. is the desired output (displaying the new calculated field FAMILY_NAME)

I need the output to display the distinct source surname and relationship surnames that appear on the same row. for example

- source id 121572 (RUTTA) has 5 relations with the surnames of either RUTTA and HUGHES - therefore the family name(s) is HUGHES/ RUTTA.
- source id 171554 (WORTHINGTON) does not have any relations so the family name is just WORTHINGTON.
- source id 185080 (HAIGH) has 2 relations with the surnames HAIGH and WEBB therefore the family name is HAIGH/ WEBB

If there are different surname for the family (as per example 1 and 3) the family names should appear in alphabetical order.

any help is appreciated





rel-example.xls
0
Comment
Question by:tonMachine100
  • 2
3 Comments
 
LVL 32

Expert Comment

by:awking00
ID: 35130157
See attached.
family-name-query.txt
0
 
LVL 32

Accepted Solution

by:
awking00 earned 500 total points
ID: 35407820
I feel like I did a lot of work just to have my answer discarded.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question