要求对查询结果去重,根据传入的参数确定要去重的字段。假设需要根据openglScore字段去重,可以使用以下SQL查询语句:

SELECT COUNT(DISTINCT openglScore) FROM gpu_info_result_suite WHERE 1=1 AND openglScore IS NOT NULL AND vulkanScore IS NOT NULL AND openclScore IS NOT NULL AND cudaScore IS NOT NULL AND hardwareScore IS NOT NULL </if

SELECT COUNT FROM	 gpu_info_result_suite	where	 1=1 if test=openglScore != null and openglScore != AND openglScore IS NOT NULL if if test=vulkanScore !=

原文地址: https://www.cveoy.top/t/topic/iaYS 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录