请问count

Question

请求一条关于count的语句构造
表名：tab_loginlogoutSERVICECODE USERNAMECARDNUM        LOGINTIME
123           040440423      2008-12-31 下午 08:21:21
123           040440423      2008-12-31 下午 08:21:21
123           040440423      2008-12-31 下午 11:59:59
123           040440423      2008-12-31 下午 11:59:59
123           040440423      2008-12-31 下午 11:59:59
123           040440423      2008-12-31 下午 11:59:59
124           040440424      2008-12-31 下午 11:59:59
124           040440424      2008-12-31 下午 11:59:59
124           040440424      2008-12-31 下午 11:59:59
124           040440424      2008-12-31 下午 11:59:59请问如何构造一条语句得到下面的内容呢，我是想统计在某天内，同一个USERNAMECARDNUM在表中记录数大于N的记录，统计出现的个数，然后以下面的形式显示出来SERVICECODE USERNAMECARDNUM  NUM
123           040440423      6
124           040440424      4select SERVICECODE,COUNT(USERNAMECARDNUM) from tab_loginlogout where logintime between to_date('2008-12-31 00:00:00','yyyy-mm-dd hh24:mi:ss') and
to_date('2008-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') order by servicecode,USERNAMECARDNUM;
我构造的下面这条语句得到的结果是
COUNT(USERNAMECARDNUM)
                15谁能指点一下，应该如何构造这条语句呢，不胜感激

Answer 1

更正一下，上面我构造的语句多写了个SERVICECODE,
改为
select COUNT(USERNAMECARDNUM) from tab_loginlogout where logintime between to_date('2008-12-31 00:00:00','yyyy-mm-dd hh24:mi:ss') and 
to_date('2008-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') order by servicecode,USERNAMECARDNUM;

Answer 2

select SERVICECODE,USERNAMECARDNUM,COUNT(USERNAMECARDNUM) 
from tab_loginlogout 
where logintime between to_date('2008-12-31 00:00:00','yyyy-mm-dd hh24:mi:ss') and
to_date('2008-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
group by servicecode,USERNAMECARDNUM; 

Answer 3

select SERVICECODE,USERNAMECARDNUM,COUNT(USERNAMECARDNUM) as num_
from tab_loginlogout 
where logintime between to_date('2008-12-31 00:00:00','yyyy-mm-dd hh24:mi:ss') and
to_date('2008-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
group by servicecode,USERNAMECARDNUM; 

Answer 4

select SERVICECODE,COUNT(USERNAMECARDNUM) from tab_loginlogout where logintime between to_date('2008-12-31 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2008-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
group by servicecode,USERNAMECARDNUM;