英语翻译select top 4 * from shop_books where anclassid = (select anclassid from shop_books where bookid = "&request("id")&") order by liulancount ,chengjiaocount,adddate desc这段代码大概的意思就是显示,查询字段的前4个数据,而

来源：学生作业帮助网编辑：作业帮时间：2024/05/04 06:27:13

英语翻译select top 4 * from shop_books where anclassid = (select anclassid from shop_books where bookid = "&request("id")&") order by liulancount ,chengjiaocount,adddate desc这段代码大概的意思就是显示,查询字段的前4个数据,而
英语翻译
select top 4 * from shop_books where anclassid = (select anclassid from shop_books where bookid = "&request("id")&") order by liulancount ,chengjiaocount,adddate desc
这段代码大概的意思就是显示,查询字段的前4个数据,而我现在想让他显示,这个数据和这个数据紧挨的三个数据.就像
1
2
3
4
5
如果request("id")=2
我想让这段代码显示 2 3 4 5 我该如何写呢,

英语翻译select top 4 * from shop_books where anclassid = (select anclassid from shop_books where bookid = "&request("id")&") order by liulancount ,chengjiaocount,adddate desc这段代码大概的意思就是显示,查询字段的前4个数据,而
这个不是ASP代码,是SQL语句
从shop_books数据库中查询bookid = "&request("id")&"的anclassid
然后从shop_books数据库中查询top 4（最上面的记录）
anclassid = 刚才查询的anclassid
然后按照 liulancount ,chengjiaocount,adddate desc 排序
楼上的是"select * from shop_books where anclassid = 31"
补充
select * from shop_books where anclassid = (select anclassid from shop_books where bookid = "&request("id")&") and anclassid = (select anclassid from shop_books where bookid = "&request("id+1")&") order by liulancount ,chengjiaocount,adddate desc
用AND连接

我想查询access数据库中字段anclassid为31的记录，anclassid的类型为数字,该怎么写呢?

从表shop_books前4个表项中查询
anclassid = 表shop_books中bookid为request("id")的ID值，然后把bookid的值按照liulancount ,chengjiaocount,adddate属性的综合降序排列
（request("id")这是提取上个页面或者本页面传送过来的ID值）
也就是说要查询的是 anclassid 的值<...

全部展开

收起

select top 1 英语翻译select top 4 * from shop_books where anclassid = (select anclassid from shop_books where bookid = &request(id)&) order by liulancount ,chengjiaocount,adddate desc这段代码大概的意思就是显示,查询字段的前4个数据,而请问 select top 1 1 from ... 英语翻译select 如何翻译 select max(account_id ) from(select top 5 account_id from account)子查询没起作用为什么? SELECT sql语句中参数乘法select top 4 *from UserInfowhere ID not in(select top 12 idfrom UserInfo ) 这个语句里面 12 用 3*4表示该怎么写啊4是第一个参数 3是第二个参数 ‘｛0｝‘ * （‘｛1｝’-1）这么写不对啊我这 sql=select top 1 * from news order by tim desc 中的top 1是什么作用?如题 select top 1 ID from Net_dictionary,其中top1 ID指的是什么? sqltext4=select top 2 * from stock order by Look_Count desc是什么意思? 英语翻译中国排行榜,英文翻译是CHINA TOP,还是top china top top top top top top top