4 ms·
Huh? If you have a table with attributeid, sampleid and value how would you count how many samples have a value in any attribute? Exists subquery?
by yread 7y ago
Huh? If you have a table with attributeid, sampleid and value how would you count how many samples have a value in any attribute? Exists subquery?
- matwood 7y agoIn your example you must also have another table, 'sample' with all the samples. So yes, you would use an exists or in subquery with the table you suggested.