【SQL达人们来帮帮忙哦】,该怎么解决

2012-04-11

【SQL达人们来帮帮忙哦】SQL codeselect top + NUMCount + * from tb_Student whereID not in ( select t

【SQL达人们来帮帮忙哦】

SQL code

select top "                           + NUMCount + " * from tb_Student where  ID not in ( select top "                           + number + " ID from tb_Student where fengcai=" + num + "   order by ID desc )and fengcai=" + num + " order by ID desc

请问——我要在这个里面再加一个城市来查询该怎么拼接我拼接几次都报了 order 附近错误。

[解决办法]

C# code

  string city = "重庆";            int NUMCount = 10;            int number = 100;            int num = 5;            string s = "select top " + NUMCount + " * from tb_Student where  ID not in ( select top "                                       + number + " ID from tb_Student where fengcai=" + num + " order by ID desc ) and fengcai=" + num + " and city='" + city + "' order by ID desc";
[解决办法]
select top "+NUMCount+" from tb_Student where ID not in(select top "+number+" ID from tb_Student where fengcai="+num+" and city='"+重庆+"') and fengcai="+num+" and city='"+重庆+"' order by ID desc

热点排行

asp.net

【SQL达人们来帮帮忙哦】,该怎么解决