I have a working query that retrieves the data that I need, but unfortunately it is painfully slow (runs over 3 minutes). I have indexes in place, but I think the problem is the multiple dependent sub
This problem may seem like school work, but it isn\'t. At best it is self-imposed school work. I encourage any teachers to take is as an example if they wish.
I have this query: select acc_num from (select distinct ac_outer.acc_num, ac_outer.owner from ac_tab ac_outer
I\'m having this Mysql query, It works: SELECT nom ,prenom ,(SELECT GROUP_CONCAT(category_en) FROM (SELECT DISTINCT category_en FROM categories c WHERE id IN
I\'d like to create a LINQ query that returns the sum of all quantities for a given productnumber for a parent account and all it\'s child accounts.
this is an attempted fix to a crystal reports use of 2 sub reports! I have a query that joins 3 tables, and I wanted to use a pair of sub selects that bring in the same new table.
I am making a website where users add the place where they have visited. There is 4 main tables users (user_id,name )
In my project, Lines can be grouped and a Group has a type which can be either Crossing (1) or Parallel (2). I need to find all lines which has at least one group of a 开发者_JAVA技巧specified type (i