see here

I have a column in a table with numbers:

1
2
3
2
1

the way I have done the tables relationships etc, I need now to have an SQL query that will return the rows that have the numbers with the max-occurrences
those rows here would be 1st and 5th [containg number 1 which occurrs 2 times {which is max}] and 2nd and 4th [containg number 2 which also occurrs 2 times]

I tried max(count(*)) but max wants column not int

I then tried:

SELECT COLUMN_WITH_NUMBERS, COUNT(*) AS cnt_occur
FROM TABLE
GROUP BY COLUMN_WITH_NUMBERS
ORDER BY cnt_occur desc;

so I now have

so I want the 1st and the 2nd column of the results, can I somehow filter the results? I only use SQL
thank for reading and helping!

Does your database support subqueries? If it does you can use
SELECT column_with_numbers, occur FROM table where occur= (select count(*) as occur from table group by column_with_numbers).
Don't remember if you can use 'occur' this way, but I think you can. If your database doesn't have subqueries, you need to use two - first find the maximum (SELECT count(*) INTO variable...) and then find all that have the same.

SQL is not my strong point, and this is really ugly, but it works in PostgreSQL. There MUST be a better way!

I have this table:

After populating it with a bunch of numbers, i did this query.

have you tried using a view?

no. I did not. is this the only way? I tried what you proposed guys but none worked for me. let me get back to the main problem i have. I want this kind of SQL code to work [this time I'll use some better names for variables]

SELECT customer_ID, MAX(COUNT(*))
FROM ORDERS;

the above sql query has what i call MAX(COLUMN_HERE) problem :P
this is supposed to count the occurrences of customer_ID in ORDERS table and give the MAXIMUM of the occurrences. What I want to do, is to have the one or more customers that have equal occurrences so I could print their names and their telephones so we can give them a prize or something like it.
damn!

so if ORDERS has this data:
I somehow want to be able with an SQL query to find the names and telephone numbers [via another table] of the customers that have done the most orders. so I need their customer_ID. in this case I want to get customer 1 and customer 3 [both ordered 2 products which is the max here]

I really hope this time I made myself clear and that you can help me on this. thanks in advance

If I understand your problem correctly...this may help
select customer_id from orders group by customer_id having count(*)=(select max(number) from (select count(*) as number from orders group by customer_id) as something);

The subquery (select max(number) from (select count(*) as number from orders group by customer_id) as something) should return you the maximum number of orders from one client.

the way to do it with a view is to make one from your first query:

create view v1 as
select id, count(*) ct
from table
group by id;

then add to your main query:

select ...
from...
where id in (select id from v1 where ct = select max(ct) from v1)