Đã hoàn thành

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.

Kĩ năng: SQL, Oracle, MySQL

Về khách hàng:
( 69 nhận xét ) Eight Mile Plains, Australia

ID dự án: #34366747

Được trao cho:

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 Thêm

$25 AUD trong 1 ngày
(27 Đánh Giá)
4.3

25 freelancer chào giá trung bình$42 cho công việc này

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 trong 1 ngày
(145 Nhận xét)
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 Thêm

$90 AUD trong 1 ngày
(51 Nhận xét)
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 Thêm

$10 AUD trong 7 ngày
(23 Nhận xét)
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 trong 3 ngày
(12 Nhận xét)
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 Thêm

$30 AUD trong 2 ngày
(7 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
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 trong 1 ngày
(2 Nhận xét)
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 trong 1 ngày
(7 Nhận xét)
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 Thêm

$250 AUD trong 3 ngày
(7 Nhận xét)
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 Thêm

$100 AUD trong 2 ngày
(4 Nhận xét)
3.2
(1 Nhận xét)
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 Thêm

$20 AUD trong 1 ngày
(1 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
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 Thêm

$15 AUD trong 1 ngày
(2 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

$20 AUD trong 2 ngày
(0 Nhận xét)
0.0
PriyaRathore5766

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

$10 AUD trong 1 ngày
(0 Nhận xét)
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 Thêm

$13 AUD trong 1 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0