select top 10 * from (select top 40 * from a order by id asc) top_n order by id desc以上这句是你写的,取出表A中第31到第40记录（SQLServer2005,以自动增长的ID作为主键,注意：ID可能不是连续的.）我想问下能不能

请问 select top 1 1 from ... select max(account_id ) from(select top 5 account_id from account)子查询没起作用为什么? select top 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是什么意思? 请教下．以下那个语句从表TABLE_NAME中提取前10条记录.A．select * from TABLE_NAME where rowcount=10B．selectTOP 10 * from TABLE_NAMEC．select TOP of 10 *from TABLE_NAMED．select * fromTABLE_NAME where rowcount select top 10 * from (select top 40 * from a order by id asc) top_n order by id desc以上这句是你写的,取出表A中第31到第40记录（SQLServer2005,以自动增长的ID作为主键,注意：ID可能不是连续的.）我想问下能不能 select * from (select a.*,rownum aa from table a ) where aa=10 sybase可以取范围随机数吗select top 2 course_id from csr_len_course order by newid() 随机数2可以用num select * from book limit , 一道C语言选择题,33.假设所有的选课成绩都已确定,显示“101”号课程成绩最高的10%记录信息,正确的SQL命令是（ ）A.SELECT * TOP 10 FROM 选课 ORDER BY 成绩WHERE 课程号=”101”B.SELECT * PERCENT 10 FROM 选 两条Oracle取第一条语句的区别select top 1 * from table order by a andselect * from (select * from table order by a )C where rownum=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 * from a union select * from b 能详细说下么 select from 表 和select from [表]有什么不同? GROUP 附近有语法错误SELECT TOP 5 * FROM CPOE_BRSYK WHERE KSDM=201 AND BRZT=0ORDER BY RYRQ GROUP BY BQDM select count(*) from 怎么使用