DB2 on Cloud: Recursive SQL statement to select all children (even grand and great grand children) ids.

I am using Db2 on Cloud database. the scenario is users can create posts, and other users can create comments. Each post/comment has corresponding data in another database that requires being deleted too once any post/comment is deleted. So I need to fetch every comment id on a post being deleted and all of the comments of the comments, and all the comments of those comments, and comments on those comments (could go on forever). I am having difficulty writing this what seems to be recursive SQL statement to select all of the id's for all these elements.

What I've been trying: SELECT CONNECT_BY_ROOT id AS id, parentId AS parentId, threadId AS threadId, LEVEL AS level FROM post_comment START WITH parentId = 1 CONNECT BY threadId = id

Gives error: "Unexpected token 'CONNECT BY' following "", expected """

I have been on this issue for days with no progress. I'm too busy to chat via a call or session but if you could simply write up this SQL statement for me correctly and it return all the child ids based on the post/comment parentId I would gladly pay you for your efforts.

Kemahiran: SQL, Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data

Tentang Klien:
( 0 ulasan ) Las Vegas, United States

ID Projek: #34739486

17 pekerja bebas membida secara purata $447 untuk pekerjaan ini

(33 Ulasan)

DB2 on Cloud: Recursive SQL statement to select all children (even grand and great grand children) ids. Hi, hope you are doing well, I am free nowadays and can start your work. For my experience kindly once have a look Lagi

$450 USD dalam 2 hari
(13 Ulasan)

Hi i think so connect by dont used in Db2. Which db2 version u are working right now. I need the dummy table data and the dymmy output u want I have 13 yearsof experience in sql development and worked in more than 300 Lagi

$600 USD dalam 600 hari
(21 Ulasan)

I'm a UK based database developer/designer with over 18 years of experience in various databases, including Oracle, SQL Server, PostgreSQL and MySQL. I'm also an Azure certified data engineer with experience in the ETL Lagi

$500 USD dalam 7 hari
(17 Ulasan)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lagi

$750 USD dalam 6 hari
(1 Ulasan)

Senior SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipatin Lagi

$500 USD dalam 7 hari
(24 Ulasan)

hi, this is a very simple requirement, worth only 30$. i have 20+ years experience on web and databases and can fix this. what os and db2 version do you use ? this oracle syntax is available only on some versions. re Lagi

$250 USD dalam sehari
(1 Ulasan)
(5 Ulasan)

Hi I am interested in your job. I'd like to discuss on private chat. Hope to hear from you. Best regards

$500 USD dalam 7 hari
(2 Ulasan)

Hi! I am skilled writer with the vast skills and qualifications necessary for this job. I have experience in SQL, Database Administration and Database Programming. I am confident that I can produce high-quality work Lagi

$250 USD dalam 3 hari
(0 Ulasan)

Hi, I am artificial intelligence engineer with more 8 years of experience in data science & database programming Feel free to contact me for further details. Let's have a quick chat to discuss in detail. Looking forwar Lagi

$500 USD dalam 7 hari
(0 Ulasan)

Hi, Dear. I have a lot of experience in web development. I think myself a satisfied developer for your job. I can work fulltime remotely for you. I will wait for you reply. Sincerely.

$500 USD dalam 7 hari
(0 Ulasan)

Greetings! i read your project details and i understood. I can help you with your project at a high level! I have rich experience in WEB developing. My skills and experience is a great match for your needs. Looking f Lagi

$300 USD dalam 6 hari
(0 Ulasan)

Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert DOMINIC and i hope to cooperate with you on your project. CERTIFIED SQL DEVEL Lagi

$750 USD dalam sehari
(0 Ulasan)

Hi, Please message me and I'll get you the DB2 SQL statement you need. I'm Colorado-based but currently in Boston (Eastern Time); message me at any hour though. Thanks! RC

$250 USD dalam sehari
(0 Ulasan)

Hi Dear client I have already read your requirement very carefully. I am a new freelancer, but I have a lot of experience and skills in Database like Mysql, sql, Mongodb etc. In addition, as help of powerful algorithms Lagi

$250 USD dalam sehari
(0 Ulasan)

Hi, I can help you on your Select/Delete statements. I charge $50/hr. I would require a walk through of your code before we start off. Please message me to discuss further. Thanks.

$500 USD dalam 7 hari
(0 Ulasan)