sql多表联合查询语句该怎么写

Question

如题，看看这个语句分页要怎么写

SELECT TOP 10 A.User_Code,A.User_Sex,C.PropertyInstance_Value,A.PhoneNo FROM Base_UserInfo A,
Base_UserRole B,

Base_AppendPropertyInstance C

WHERE A.User_ID=B.User_ID AND

B.User_ID=C.PropertyInstance_Key AND

C.Property_Control_ID='ChatName'

Answer 1

DECLARE @pageSize INT =10, @pageIndex INT=1 SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY User_ID) AS rowNum, A.User_Code, A.User_Sex, C.PropertyInstance_Value, A.PhoneNo FROM Base_UserInfo A,Base_UserRole B,Base_AppendPropertyInstance C WHERE A.User_ID=B.User_ID AND B.User_ID=C.PropertyInstance_Key AND C.Property_Control_ID='ChatName' ) AS tb WHERE tb.rowNum BETWEEN @pageIndex-1 * @pageSize AND @pageIndex * @pageSize

Answer 2

有一种分页叫 row_number