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.
17 freelances font une offre moyenne de 447 $ pour ce travail
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
Hi I am interested in your job. I'd like to discuss on private chat. Hope to hear from you. Best regards
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 Plus
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 Plus
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.
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 Plus
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 Plus
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
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 Plus
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.