Gary Leong

a表的id和b表的id相关联，只需判断一下即可。select *, case when (select count(*) from b where id = a.id)>0 then 1 else 0 end as flag from a如果你是想a表和b表的字段和id这两列都一样，才将flag显示为1的话，用下面的查询：select *, case when (select count(*) fr

参考资料：SQL分页语句 1. 第一种方法：效率最高 SELECT TOP 页大小 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1 ) as A WHERE RowNumber > 页大小*(页数-1) --注解：首先利用Row_num...