select the most commonly repeated value from the table

#1 (**permalink**) 07-07-2008, 05:02 PM

write an SQL query to select the most commonly repeated value from the table below.

id values
1 1
2 2
3 1
4 3
5 1
6 2

I try this, but not work. Please help. thnaks
select a.* from test a,(

select value,count(value) as num from test

group by value)b where a.value=b.value

order by b.num desc

#2 (**permalink**) 07-07-2008, 08:55 PM


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)

;

#3 (**permalink**) 07-07-2008, 08:56 PM

in the above, the table tv is your table named 'test'

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

User Name		Remember Me?
Password

select the most commonly repeated value from the table

ANSWER(S):