Make nested sql query like grandfather -> father -> son details query
₹600-1500 INR
K zaplacení v momentě doručení
Hello .
I have a database which have 2 columns
username and refBy
username -> its a user whose admin is refBy column
i have 3 level data
like
mdis (username) -> rajdeep (refBy)
dis (username ) -> mdis (refBy)
ret (username) -> dis (refBy)
As you can see here rajdeep is creator of mdis ,
mdis is creator of dis ,
dis is creator of ret ,
I need a query so that if i fetch rajdeep records it will give details mdis , dis and ret alongs with its creator , its like grandfather details , if i select grandfather name it will give all his son and son of son details along with father name .
I tried this query "select username,refBy from refByTmp where refBy in (SELECT username from refByTmp where refBy='rajdeep') or refBy='rajdeep'"
But its showing only 2 level data .
*Milestone will be released only after getting working query*
I have also attached sample database
Identifikační číslo projektu: #18990529
O projektu
Uděleno uživateli:
Hello Firstly although select sub queries as per your example could be used for this solution, they are extremely inefficient and on larger datasets will almost certainly overload mysql resources and/or processing t Další
21 Freelnceři na tento projekt zveřejňují nabídky v průměru ₹1207
Hello Sir, I have understood your requirement of nested SQL statement. I can provide it to you and show you at my localhost also. Looking forward for your reply. Thanks & Regards, Anshulika Bansal
I am a database architect and having more than 14 years of experience in IT industry. I can help you to derive the sql query. Let me know if you want to discuss further. My Technical background • A goal-oriented Další
Hello, I've done many of these kind of 'nested' queries, or autoreferenced tables if you like. Working with families tables, as well as payroll formulas which reference one another. Please feel free to contact me, I' Další
Hi i already have the query and need to chnges a se per ur requirement if u can able to give sample db i will do chnges and gice u the query Ping me if u r interested
Hello, Using nested Select is much complicated for this case. You need to use joins. I created the sample table, and get the result as you want: mdis,dis,ret But I tried this on MsSql. I think the logic must b Další
I went through the requirement and It can be done using nested query I can quickly help you and release the milestone once done
Hello there, Gone through your details and after reading over your application this looks like a perfect fit for my skill sets!! I am a Database programmer with 12+ yrs of experience, I am having a good project Další
hi i have worked on such query earlier when my project was for multi-level marketing. i can write this script. lets connect. award me the project only after the query is working.
I am a PHP developer working with HTML, CSS, JAVASCRIPT, PHP, Codeigniter and JQERY and laravel. My competencies include PHP, Codeigniter, APIs, HTML, CSS, JAVASCRIPT, PHP, JQERY, AJAX1 and MYSQL.
Hi , I am new to freelancer. but having more than 6 years experience in php mysql project.I can solve your query.
Hi, This is karthik who works in TCS, India as SQL developer. I can complete your work in small span of time. pay be if you are satisfied with my work and friendly nature. Thanks, karthik.
Just started as a freelancer. Can help you with your problem. having 2+years of experience. looking forward to discussing with you.
Hello I have immense experience working with SQL and can get it done for you in no time. Thanks.
Dear Hiring Manager, I have read your problem and I'm willing to solve your problem if you give the chance. Hope you will give me the chance.
Hi! I made a query for you. For the case when you have 3 levels I can not attach to the application. Get into contact with me.