Loading

How to write down a query for repeted value in sql

Anjali Khan

8y750

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anjali Khan8y ago
Hi NileshSo my query like this select emp_name, count(emp_name) e from employee group by emp_name order by e desc;
Nilesh Patil8y ago
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;