SELECT count(company_id) as c_login,company_id,admin_id
FROM company_login
GROUP BY company_id,admin_id
having count(*)>=3
FROM company_login
GROUP BY company_id,admin_id
having count(*)>=3
解决方案 »
- c#如何做出来仿iphone上的那种文字滑动效果?
- 如何用C#将pdf格式的文件转换为jpg格式(pdf文件中存的是图片)
- 谁能给解释下Focus意思?
- 关于写字板的退出按钮怎么写啊
- 文件“D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\aaa.zip”正由另一进程使用,因此该进程无法访问该文件。
- javascript和this.SmartNavigation=true冲突?怎么解决呢?
- 基本的技术难题!
- 求算法问题,
- 不改变原来的类,监听属性值的修改,怎么实现?
- 谁能给我些C#中操作ADODB的代码,100分相送!
- Access 与 ListView 的连接问题
- MDI窗体的背景问题
select company_id from(SELECT count(company_id) as c_login,company_id,admin_id FROM company_login GROUP BY company_id,admin_id) a where c_login>3
SELECT count(*) ,admin_id FROM company_login GROUP BY admin_id having count>=3
然后从试图里做selectSELECT count(company_id) as c_login,company_id,admin_id FROM company_login where(admin_id in (select admin_id from view_1) )如果用存储过程实现可以把建立视图的过程写到临时表里。后面的就一样了。
谢谢你的提议,但我建立存储过程后又碰到新的问题,麻烦你了,解决完马上给分
CREATE proc p_tongji
@cishu int, --登陆次数
@tiaojian varchar(4000) = '' -- 查询条件 (注意: 不要加 where)
as
declare @strsql varchar(5000) -- 主语句
declare @sql varchar(5000)
begin
create table #table1
(
c_login int,
companyid int,
adminid int
)
if @tiaojian =''set @tiaojian='1=1'
set @sql= 'insert into #table1 SELECT count(company_id) as c_login,company_id,admin_id FROM company_login where ' + @tiaojian + ' GROUP BY company_id,admin_id'
exec (@sql)
set @sql='select count(*) as num ,adminid from #table1 group by adminid'
exec (@sql)
end
GO
以上是存储过程
代码:Set rs=conn.execute("execute p_tongji 1,'"&tiaojian&"'")'execute p_tongji 登陆次数,条件
'set rs=conn.execute("select * from company_login")
do until rs.eof
If rs("adminid")=0 Then
admin_xingming="系统管理员"
else
m_SQL = "SELECT admin_xingming FROM admin where admin_id="&rs("adminid")
response.write m_sql
Set rst = conn.Execute(m_SQL)
admin_xingming=rst1(0)
rst.Close
End if
%>
<tr><td><%=rs("num")%></td><td><%=admin_xingming%></td></tr>
<%
rs.movenext
Loop
rs.close
set rs=nothing
%>
现在这样出现在另一种错误提示:[Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt