这断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
相关问答：
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),执行速度慢的要死，但是如果把(xxf>0 and ......
PB中开发的。
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
环境：1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表，中文全部显示为乱码。
......
（1）string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
（2）string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
