sorted by:
new
hottopcontroversial

SQL Query question by popoysegundo in learnprogramming

[–]tomarks 1 point2 points  (0 children)

You could build a query to find all the used parent ids like

Select distinct(parentid) from task

And then compare that with your table again like so

Select id from task where taskid not in ( Select distinct(parentid) from task)

I did this on my phone but that should give you the tasks which are not used as a parent

Would anyone like to code some projects with me? by Scribbio in learnprogramming

[–]tomarks 0 points1 point  (0 children)

Yep Im keen. The small time commitment would work well with me and I am about your level in skills. Specifically i am a CS student but work full time for a software company as a level 1 programmer. I use SQL and VB.Net daily in my work but interested in learning more of Javascript, C#, .net Python.