从relation-sql语句中选择最常见的值

select top 1 software 
from your_table 
group by software
order by count(*) desc 

这取决于您是否要使用标准的SQL或特定于供应商的扩展(另一个海报有一个“top n”查询,即 不 标准)。一个标准的解决方案是。

SELECT software, COUNT(1) 
FROM tablename
GROUP BY software
HAVING COUNT(1) = (
  SELECT MAX(sc) FROM (
    SELECT software, COUNT(1) sc
    FROM tablename
    GROUP BY software
  )
)

注: 如果多个软件绑定的次数最多,则可能返回多行。

你可以用很多方法来做,但最简单的方法是

SELECT item  
FROM (SELECT item FROM your_table GROUP BY item ORDER BY COUNT(*) desc)  
WHERE ROWNUM<=1;