sql语句中参数乘法select top 4 *from UserInfowhere ID not in(select

来源：学生作业帮编辑：作业帮分类：英语作业时间：2024/05/06 16:14:41

sql语句中参数乘法
select top 4 *
from UserInfo
where ID not in(
select top 12 id
from UserInfo ) 这个语句里面 12 用 3*4表示该怎么写啊
4是第一个参数 3是第二个参数 ‘｛0｝‘ * （‘｛1｝’-1）这么写不对啊
我这个意思得怎么写啊
求救!

string.Format("select top 4 * from UserInfo where ID not in( select top ({0} * {1}) id from UserInfo )","3","4");
再问： 3 和 4都用参数替代 string.Format(@"select top '{0}' *from UserInfo where ID not in ( select top ({1}-1)*{0}) ID from UserInfo)",pages,nb); pages等于3，nb等于4
这样怎么写尼
再答：要转成字符串。。。
C#:
string.Format(@"select top {0} * from UserInfo where ID not in ( select top ({1}-1)*{2}) ID from UserInfo)",pages.ToString(),nb.ToString(),pages.ToString());
pages等于3，nb等于4
TOP 后面是INT，不要用‘

sql语句中参数乘法select top 4 *from UserInfowhere ID not in(select select id from (select * from tree)这个sql语句有什么错吗 SQL 语句 "SELECT * FROM {{table}} WHERE `fleet_end_time` sql如何取交集有这样两条sql语句select distinct id from a where id='123'se sql语句中SELECT后面*表示什么 select top 10 * from (select top 40 * from a order by id asc 请教sql语句,像select …from wsdy_zb t where t.id =:id order by no 请问sql="select * from 招聘信息 order by id sql="select * from "&data&" where id="&myid&"" 在数据库中没有data 这 sql 中 select * from A left join B on A.id=B.id where A.id=?如 mysql select * from lsdl_user where id in (1,2,3,4,5)中in()最多 select id,name from student where id in ( select id from sco