这断SQL可以简化吗？
SELECT top 50 * from [NC_Article] WHERE ClassID = 11 OR ClassID = 12 OR ClassID = 13 OR ClassID = 14 OR ClassID = 15 OR ClassID = 16 OR ClassID = 17 ORDER BY MonthHits DESC
where classid between 11 and 17
SQL code:
SELECT top 50 * from [NC_Article] WHERE ClassID in (11,12,13,14,15,16,17) ORDER BY MonthHits DESC
SQL code:
SELECT top 50 * from [NC_Article] WHERE ClassID between 11 and 17 ORDER BY MonthHits DESC
SELECT top 50 * from [NC_Article] WHERE ClassID between 11 and 17 ORDER BY MonthHits DESC
相关问答：
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
大家帮忙看看这2个sql语句哪个查询的速度更快点。谢谢帮忙。比较着急。在做性能测试。
select * from
表A LEFT OUTER JOIN 表B ON (表A.id || ' ' =表B.id) ,表C , 表D, 表E
Where其他条件
select * ......
环境：1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表，中文全部显示为乱码。
......
已知从B,表中找出ID, NAME两项与C表相同的数据，再依据B表中经过查询出来的ID,CODE两项数据查询与A表ID,CODE两项相同的数据中对应的EMAIL来，并列出如下D表的形式，不知我是否表示清楚？麻烦帮我列一下公式好吗？万� ......
