CareerCup

select userid, count(userid) as num
from table
group by userid
order by num desc limit 1

SELECT user FROM Table GROUP BY user HAVING COUNT(user) = (SELECT COUNT(user) FROM Table GROUP BY user ORDER BY COUNT(user) DESC LIMIT 1)

The question hinted that the user id is not a unique field. I will do it this way

select t.uid, max(t.countUid)
from
(select uid, count(uid) as countUid from yourtable group by uid order by countUid desc) t

;with ctegtloginattempt
as
(select
DENSE_RANK() over (partition by userid order by loggedintime) as loginattempts, userid
from useridlogintbl
)

select userid, max(loginattempts) as loginattempts from ctegtloginattempt
group by userid
order by loginattempts desc

select * ,count(ids) from logins group by ids;

SELECT count(date), id FROM user GROUP BY user.id ORDER BY date ASC LIMIT 1;

SELECT count(date), id
FROM user
GROUP BY user.id
ORDER BY date ASC
LIMIT 1;

select top 1 userid from (
select userid,count(date)count
from table
group by userid)c
order by COUNT desc

select * from (select userid,count(*) from table group by userid ) where rownum=1;

select user_id, count(user_id) from user_table group by user_id order by count(user_id) DESC limit 1;

select user_id, count(user_id) from user_table group by user_id order by count(user_id) DESC limit 1;

Select user, max(log_count) from (Select count(date) AS log_count, user_id AS user from table group by user_id) ;

#include<iostream>
using namespace std;
int sort(int arr[],int l);
int main()
{
	int arr[10] = {3,6,2,1,0,5,7,8,3,4};
	int arr2[10]= {4,1,6,3,8,10,11,5,9,2};
	sort(arr,10);
	sort(arr2,10);
	int j=0;
	for(int i=0;i<10;i++)
	{
		while(arr[i]>arr2[j])
		{
			cout<<"("<<arr[i]<<","<<arr2[j]<<")";
			j++;
		}
	}
}

int sort(int arr[],int l)
{
 int min;
 int k=0;
 for(int i=0;i<l;i++)
 {
 	min =arr[i];
 	for(int j=i;j<l;j++)
 	{
 		if(min > arr[j])
 		{
 			min = arr[j];
 			k=j;
 		}
 	}
 	arr[k] =arr[i];
 	arr[i] = min;
 }
}

If this is a SQL question, it's pretty straight forward. The below returns a sorted list with the most logins at the top. If you need only to return a single row, simply turn this into a sub-query and select user_id from sub-query where rownum = 1.

select
user_id
,count(date) as logins

from table_name

group by
user_id

order by count(date) desc