Find Jobs
Hire Freelancers

SQL Help help me write a Select Query

$10-30 AUD

Concluído
Publicado há quase 2 anos

$10-30 AUD

Pago na entrega
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.
ID do Projeto: 34366747

Sobre o projeto

24 propostas
Projeto remoto
Ativo há 2 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 structure already to output the desired table. Thanks, Milan
$25 AUD em 1 dia
5,0 (30 avaliações)
4,4
4,4
24 freelancers estão ofertando em média $43 AUD for esse trabalho
Avatar do Usuário
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 em 1 dia
5,0 (157 avaliações)
6,8
6,8
Avatar do Usuário
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 it. Pls share me your RDBMS and we can discuss. Waiting for your response if interested. Thank you!!!
$90 AUD em 1 dia
5,0 (56 avaliações)
6,3
6,3
Avatar do Usuário
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, then message me, please.
$250 AUD em 3 dias
5,0 (8 avaliações)
5,6
5,6
Avatar do Usuário
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 my skills. I can fix your site issue successfully I would like to know a little more about your project via chat. I am looking forward to having further discussions with you and can start working immediately. Best regards, Giáp Văn Hưng
$10 AUD em 7 dias
5,0 (42 avaliações)
5,3
5,3
Avatar do Usuário
❤️ 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 contact me to discuss more, looking forward to work with you. Thanks!
$20 AUD em 1 dia
5,0 (14 avaliações)
5,1
5,1
Avatar do Usuário
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 em 3 dias
4,9 (14 avaliações)
4,7
4,7
Avatar do Usuário
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 em 1 dia
5,0 (3 avaliações)
4,5
4,5
Avatar do Usuário
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 are interested. I am always ready. Best regards! Juan.
$30 AUD em 2 dias
4,6 (11 avaliações)
4,9
4,9
Avatar do Usuário
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 em 1 dia
4,5 (11 avaliações)
4,1
4,1
Avatar do Usuário
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 em 1 dia
5,0 (2 avaliações)
3,5
3,5
Avatar do Usuário
Hi, I can write mysql query as per your requirement. Looking forward to hearing from you to proceed. Thank you.
$45 AUD em 1 dia
5,0 (5 avaliações)
3,4
3,4
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
2,4
2,4
Avatar do Usuário
"purple" Hi, I have many experience in SQL. I'd like discuss about your project in detail. Looking for your reply.
$50 AUD em 7 dias
4,2 (2 avaliações)
2,0
2,0
Avatar do Usuário
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 engineering in a good amount of time. I have experience in PHP, Flutter, SQL, MYSQL, Oracle, C#, C++, .net core, .net Framework, web engineering, web designing, web content development, client/server-side scripting, web server, and network security configuration, e-commerce development, API development, and so on. I am confident that I can be a good employee for you because I know what you want. I assure you that I will do my best for your job. I am available 24/7 both online and offline. You can find me on Skype. Your every call/message is important to me. I will be available at least 50 hours per week and ready to assist you on your project at your call. Yours Faithfully Mr. Shahzaib Rasool.
$20 AUD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello there, Having required knowledge in SQL and can deliver the required functionalities within given period of time
$10 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 consider me. Thank you. Kind Regards.
$13 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Purple. This can be achieved with a single line of code. I have solved such problems a lot of times. Let's connect so that we can solve the problem quickly.
$12 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
purple. I went through your requirement and have the flowchart ready. We will have to use two cursors. Connect with me for further discussion related to the problem statement. Also I would like to know on which platform you are writing SQL. My background : I am a Mainframe developer with the extensive experience on COBOL and DB2/SQL. I am working in IT since 8 years.
$20 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Eight Mile Plains, Australia
5,0
71
Método de pagamento verificado
Membro desde ago. 28, 2015

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.