这样试试
select * from (
SELECT film_name, COUNT(FILM_NAME) AS COUNT FROM VOD_HIS where ORDER_TIME BETWEEN '0:0:0' and '23:59:59' GROUP BY film_name
)a,VOD_HIS b
where a.FILM_NAME=b.FILM_NAME and b.FILM_TYPE_ID=1
ORDER BY COUNT DESC
select * from (
SELECT film_name, COUNT(FILM_NAME) AS COUNT FROM VOD_HIS where ORDER_TIME BETWEEN '0:0:0' and '23:59:59' GROUP BY film_name
)a,VOD_HIS b
where a.FILM_NAME=b.FILM_NAME and b.FILM_TYPE_ID=1
ORDER BY COUNT DESC
解决方案 »
- 这sql语句有办法优化吗?
- 判断UPDATE、INSERT、DELETE操作的函数分别是什么?
- SQL2000问题请教高手
- 怎麼用script修改已經有數據的表呢,例如primary Key, Default....
- SQL Server 2000如何实现两个数据库中相同格式的两个表格的数据合并?
- 还原错误??
- sqlserver2005 触发器的一个小问题
- 数据库作业,求高手帮忙
- 50分求助:这样一条聚合查询语句怎么写?
- 如何从数据表的两个数字字段中,取其中数字较小的字段?谢谢!
- order by 问题
- 我的一表中有一大字段fbnr,存的是.htm格式的文件,现需要将字段fbnr存放对应的.txt格式的文件,该如何做呵。。,,在线等,,问题解决立
where ORDER_TIME BETWEEN '0:0:0' and '23:59:59'
and exists (
select 1 from FILM_INFO
where FILM_NAME=VOD_HIS.FILM_NAME
and FILM_TYPE_ID=1
)
GROUP BY film_name
"列名 'FILM_NAME' 不明确。"
因为你的两个表中有同名的字段'FILM_NAME' ,你需要指定是那个表的'FILM_NAME' 字段试试这个语句:
SELECT VOD_HIS.film_name, COUNT(VOD_HIS.film_name) AS COUNT FROM VOD_HIS,FILM_INFO WHERE VOD_HIS.FILM_NAME=FILM_INFO.FILM_NAME AND FILM_TYPE_ID=1 GROUP BY VOD_HIS.film_namee ORDER BY COUNT DESC
应该是VOD_HIS.film_name