Make nested sql query like grandfather -> father -> son details query

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 times The most efficient way is to use joins in the query. I have coded this and tested against your sample set to produce the resulting grandfather, father, son output which I can send a screen snap shot should you wish to message me and provide the sql statement to enable you to use this against your live dataset Rgds Alan

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 professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;

Hi, I am interested in the task and can do it. please ping me to discuss more. thanks.

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'll be glad to chat with you. If you select me, we can do it soon. Best Esteban

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 be the same. I can send you the T-SQL code on chat. You don't pay if it doesn't work! Thanks.

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 management experience and have worked with various software MNCs and deliver high-level enterprise level applications. I make sure your project progress smoothly and delivered in time with the agreed budget. Let’s get connected here, so we can discuss the requirements more deeply to understand and clarification on requirements so that we can ask the question, Happy to share client references. Waiting for your response! Thanks! Regards, Anubhav

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.

Please message me. We can discuss for fix price per package. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9 years experience in MS SQL Server. Please let me know more details and when we will start. Sky pe jikenjd

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.