Suoritettu

SQL Help help me write a Select Query

See attached picture of the problem.

I need help writing a query that will be able to return this output.

The input is shown in green table, only has 2 columns.

I want a list of all the IDs and the original ID if that makes sense. Please see attached example.

The green table is a transactional table where one record is linked to the previous ID.

Please note, there could be hundreds unknown amount of links to previous records so need to think of an iterative or procedural way not just 3 nested select statements or something like that.

Please start your offer with the word purple so I know you have read this project description.

Thanks for your time and understanding.

Taidot: SQL, Oracle, MySQL

Tietoa asiakkaasta:
( 69 arvostelua ) Eight Mile Plains, Australia

Projektin tunnus: #34366747

Myönnetty käyttäjälle:

MimiFL

Ok, first lets start with "purple" word. I believe you this can be solved relatively quickly, if you are interested, feel free to message me and i will show you a sample. The green table you have has pretty good struct Lisää

$25 AUD 1 päivässä
(27 Arvostelua)
4.3

25 freelanceria on tarjonnut keskimäärin $42 tähän työhön

nixtech

Hello Sir Can i have more detail? I am willing to start right away. Please check my profile for work and experience. Regards Hardeep.

$50 AUD 1 päivässä
(145 arvostelua)
6.4
Truonggiang86

Purple!!! Hello there, I've seen your attachment, to write this kind of queries we should write a recursive query. Within Oracle we can use the connect by statement, within sql server we can use with statement to solve Lisää

$90 AUD 1 päivässä
(51 arvostelua)
6.0
giaphung2k1

G'day I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel , Javascipt, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with Lisää

$10 AUD 7 päivässä
(23 arvostelua)
4.4
kaindo2017

Hi, i am an expert in SQL script writing. I have a Bsc degree in computer science. Please consider for the task i will provide the best quality.

$50 AUD 3 päivässä
(12 arvostelua)
4.4
jpdestudio

Hi,Dear client! I've read your post and I am ready to take up the task. I have rich experience in DB and I have various techs such as MySQL,Postgres,MongoDB etc. So I can do the job for sure. Please contact me if you a Lisää

$30 AUD 2 päivässä
(7 arvostelua)
4.8
vw1514518vw

"Purple"..The SQL is Ready, Tested, Working as required, Check link for table data and query output:...... [login to view URL]

$50 AUD 1 päivässä
(1 arvostelu)
3.9
SeasonedDveloper

Purple I am ready to start this job instantly according to your requirements. I would like to discuss the details with you via chat. Looking forward to hearing from you. Regards Daniyal

$20 AUD 1 päivässä
(2 arvostelua)
3.7
b2btechnology20

Hello I am a good fit for this Job I have lots of experience in this sector. I have worked for many Client before on other platforms. Thank you in advance for your time and consideration. Thanks Mahesh Kumar

$20 AUD 1 päivässä
(7 arvostelua)
3.1
SPARKtechBD

Since 2010 I am working on SQL database systems on MSSQL, Azure SQL or MySQL and ER diagram to design and build database systems. So more than 10(ten) years of experience in SQL. If you want a good delivery of work, th Lisää

$250 AUD 3 päivässä
(7 arvostelua)
3.1
DanielMue

'purple' Hello dear customer, I'm a data scientist with knowledge in SQL and worked already with different databases. This looks like you need a solution with an recursive sql command. i can solve that SQL issue for Lisää

$100 AUD 2 päivässä
(4 arvostelua)
3.2
(1 arvostelu)
1.7
denysdenysivanch

❤️ Hello. purple I have rich experience in SQL query. I've checked your attach image and I've fully understood your requirements. So i can writing query as you want. I'm sure I will complete your job perfectly. Please Lisää

$20 AUD 1 päivässä
(1 arvostelu)
1.1
csuciu38

purple Hi! I can write that query for you. I have strong skills in MySQL and a long experience in programming. I am available and ready to start working. Thank you, CristinaS

$30 AUD 1 päivässä
(1 arvostelu)
1.2
PadmajaKarekar

Purple I have created the query and output is same as what you are looking for. Just a single select used. Please message me so that I can share a screenshot of the output. Hello! I hope you are doing well. I hav Lisää

$15 AUD 1 päivässä
(2 arvostelua)
1.2
yevheniiahorbun3

hello! I read your job detail carefully. I am ready to get started working immediately. I am confident in this job as I am a sql expert Looking forward to your positive reply.

$30 AUD 1 päivässä
(0 arvostelua)
0.0
balbrad86

"purple" Hi, I have many experience in SQL. I'd like discuss about your project in detail. Looking for your reply.

$50 AUD 7 päivässä
(0 arvostelua)
0.0
shahzaibrasool1

Hello, Hope you are doing great! I am a full-stack developer with 4+ years of experience in this field, I'll help you execute your project. I have the skill to execute all visual designs from concept to finalized engi Lisää

$20 AUD 2 päivässä
(0 arvostelua)
0.0
PriyaRathore5766

Hello there, Having required knowledge in SQL and can deliver the required functionalities within given period of time

$10 AUD 1 päivässä
(0 arvostelua)
0.0
fn7014971

Purple. Hello there. Hope you are good. I have gone through your requirements and i am sure i can help you in this project as i have vast experience in MYSQL database. I have written many such queries. Hope you will co Lisää

$13 AUD 1 päivässä
(0 arvostelua)
0.0
MOUNISHNANDI

I have more than 7 years of real time experience as a Java developer. I have worked on Java 8, J2EE, Restful API, Microservices, Spring Boot, Maven, Unix, Autosys Job,JDBC,Cucumber and SQL.

$20 AUD 7 päivässä
(0 arvostelua)
0.0