select max(account_id ) from(select top 5 account_id from ac

来源：学生作业帮编辑：神马作文网作业帮分类：综合作业时间：2024/09/20 16:26:45

select max(account_id ) from(select top 5 account_id from account)子查询没起作用为什么?

我是这样理解的：因为TOP 子句用于规定要返回的记录的数目,作用于整张表,例如SELECT TOP 50 PERCENT ,只是显示整张表的一半数目,后台数据库处理还是一张表,前台查询的返回结果是不同于临时表.所以虽然你查询出前五条,但是后台数据库处理max还是作用于整张account表 .所以得到的值是整张account表中account_id的最大值.select max(account_id) from account where account_id in (select top 5 account_id from account)

select max(account_id ) from(select top 5 account_id from ac 英语翻译select top 4 * from shop_books where anclassid = (select select top 10 * from (select top 40 * from a order by id asc SELECT MAX(account) AS account FROM shop 和 SELECT MAX(accoun select*from ‘ * ’ 的意义? select * from book limit , sql语句中参数乘法select top 4 *from UserInfowhere ID not in(select select count(c) from (select b from TUserBankLogSum b group select * from a union select * from b 能详细说下么 select count(*) from table1 select count(*) from table2 sele select * from teacher where s_id in(select s_id from student select from 表和select from [表]有什么不同?