create proc hotdata
as
begin
select * from tb_detail where MM_Id in
(
select MM_Id from
(
select MM_Id count(*) as num from tb_detail
group by MM_Id
order by num
)
)
endsql分析语法说end上面的一个括号“)”附近有语法错误,求解,谢谢!!
as
begin
select * from tb_detail where MM_Id in
(
select MM_Id from
(
select MM_Id count(*) as num from tb_detail
group by MM_Id
order by num
)
)
endsql分析语法说end上面的一个括号“)”附近有语法错误,求解,谢谢!!
解决方案 »
- JavaScript 验证间歇性失效!在线等待------
- HTTP 错误 401.3 - 未经授权:访问由于 ACL 对所请求资源的设置被拒绝。 服务器上asp.net aspx的网站都打不开了
- 关于jquery和子页面向父页面传值!!急急急急,先谢谢各位神仙了
- 通过showModalDialog打开新的页面,后台代码不执行!急得吐血!
- 怎么把bool型字段写入数据库表
- 请问C#里如何将120.12345678转换成xxx·xx'xx"
- |M| 一个购物临时表在用户登录和注销再登录的时候要如何处理里面的数据!
- DataGrid刷新
- 在WEB中看水晶报表提示以下错误.
- 我的asp.net为什么运行不了??????急!!!!!
- 网页中,如何把同一行的图片和文字设置成垂直局中?
- 跪求:校园网客户端与vs里的web development sever 冲突该怎么解决
as
begin
select * from tb_detail where MM_Id in
(
select MM_Id from
(
select MM_Id count(*) as num from tb_detail
group by MM_Id
order by num
) AS T
) AS T1
end 其他的不修改,别名还是要加
1、中间的
select MM_Id count(*) as num from tb_detail
应该是
select MM_Id ,count(*) as num from tb_detail 2、缺少别名create proc hotdata
as
begin
select * from tb_detail where MM_Id in
(
select MM_Id from
(
select MM_Id ,count(*) as num from tb_detail
group by MM_Id
order by num
) aa
)
end