View Single Post
  #2 (permalink)  
Old 07-07-2008, 08:55 PM
Unregistered
 
Posts: n/a
Default 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]
Reply With Quote