Cancelled

write single line sql query for nested user search

I have a table "refBy" which have 2 column => username , refby

data is like

mdis,admin

distributor,mdis

retailer,distributor

these 3 column is example of data inside table

now i have input user "admin" and i want output data with username => mdis,distributor,retailer

since "mdis" is referred by "admin" and then "distributor" is referred by "mdis" and then "retailer" is referred by "distributor"

I need single line sql query to fetch this data within 1 hr .

Skills: MySQL, PHP, SQL

See more: write sql query joins tables example database uses, sql query search xml files, write sql query oracle 10g, sql subquery join, subquery in sql w3schools, subquery in where clause, nested queries in sql w3schools, types of subqueries in sql, subquery in select statement, subquery in sql example, subquery sql server, php, android, css, website design, graphic design, ios, write sql query label column employee title, write sql query will show senior consultants, write sql query parent child relation tables database

About the Employer:
( 20 reviews ) Hazaribagh, India

Project ID: #15765068

19 freelancers are bidding on average ₹1167 for this job

₹1050 INR in 1 day
(46 Reviews)
5.7
usama13

Inbox me to start working right now. I will build a query for you. I am ready to start work right now and will finish this project within 1 hour. Thank you waiting for your response. Relevant Skills and Experience I h More

₹2000 INR in 0 days
(28 Reviews)
5.1
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ More

₹1300 INR in 1 day
(50 Reviews)
5.0
hoisticdeveloper

Sir, I am expert php and MySQL developer, I can develop the sql query to get your desired data. It needs a SQL join query to get your data according to your needs. I am sure for this project. Relevant Skills and Exper More

₹1000 INR in 1 day
(8 Reviews)
4.9
SALESDGWEB

Hello, I will make a website for your business and sure I will make it responsive for all the web and mobile views. My Portfolio : [login to view URL] Relevant Skills and Experience I'm Full stack developer More

₹1250 INR in 1 day
(11 Reviews)
5.2
MohanKumar28

Hi, Have checked it and will write the sql query once we discussed. Pls contact. Regards, Mohan Relevant Skills and Experience PHP,Sql Proposed Milestones ₹750 INR - Cost

₹750 INR in 0 days
(34 Reviews)
5.1
perfectdone

Hi, I created the query that return these results for input paratemeter refby: admin => mdis distributor retailer mdis => distributor retailer distributor => retailer It's not just 1 line it has [login to view URL] Relevant Skills More

₹1250 INR in 1 day
(62 Reviews)
4.7
₹1300 INR in 1 day
(14 Reviews)
4.5
xinglong717

Hi Stay tuned, I'm still working on this proposal.

₹1300 INR in 1 day
(25 Reviews)
4.6
webdesky

Webdesky Info tech Pvt Ltd is the leading company in India established in 2001. We have 10+ experience for deliver IT services to our Happy and Satisfied Client We help our client's focusing their core business areas More

₹1300 INR in 1 day
(18 Reviews)
4.4
₹1400 INR in 1 day
(4 Reviews)
4.1
imonk

Hello, Hopes you are doing great:) We need more details so please open PMB for discussion and quires. We are best known for our services and our quality work, as well as client satisfaction! Relevant Skills and Exp More

₹1600 INR in 1 day
(14 Reviews)
4.1
nikunjv9

i will complete your project within time-limit. Relevant Skills and Experience i will complete your project within time-limit. Proposed Milestones ₹1300 INR - i will complete your project within time-limit. i will c More

₹1300 INR in 1 day
(22 Reviews)
3.9
mrscpro

I am ready to work on this project now. I am able to deliver you the best quality of work with lowest price and minimum time. Relevant Skills and Experience I am expert in PHP, MySQL, JavaScript, HTML, CSS, AJAX, XML, More

₹1300 INR in 1 day
(17 Reviews)
4.0
₹650 INR in 1 day
(0 Reviews)
0.0
canvasweb

i have looked into your description, and i am very much confident that i can complete this task. Relevant Skills and Experience i am experienced in SQL and is certified DB2 professional Proposed Milestones ₹1150 INR More

₹1150 INR in 1 day
(0 Reviews)
0.0
₹850 INR in 1 day
(0 Reviews)
0.0
₹675 INR in 1 day
(0 Reviews)
0.0
ramireddy0292

my expertise in SQL gets your job done Relevant Skills and Experience 3+ yrs of expertise in SQL query writing Proposed Milestones ₹750 INR - Query writing

₹750 INR in 0 days
(0 Reviews)
0.0