How to write down a query for repeted value in sql

Question

Dear frnds I have a table like employee ------------------------- EID. ENAME --_----------------------- 1 A 2. B 3. C 4. A 5. B 6. C 7. A ---------------------------- I want the display like A = 3 B = 2 C = 2 How to do this

Answer 1

Hi NileshSo my query like this select emp_name, count(emp_name) e from employee group by emp_name order by e desc;

Answer 2

Hi,

 

To get a list of values and the number of their appearances:

 

select col_name, count(col_name) c from table

group by col_name

order by c desc;

 

If you want only the most common value:

 

select col_name, count(col_name) c from table

group by col_name

order by c desc

limit 1;