ANY answer.
Re: select the most commonly repeated value from the table
[sql]
select
t0.value
from
(select value,count(value) as cnt from tv group by value) as t0
where
t0.cnt = (select max(cnt) from (select value, count(value) as cnt from tv group by value) as t1)
;
[/sql]
|