News for hackers. Stuff that matters.
Re:Medium-hard SQL interview questions by yread on Sunday May 03, 2020 @03:42AM (#23057519)
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?
Re:Medium-hard SQL interview questions by matwood on Sunday May 03, 2020 @07:42AM (#23058430)
In 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.