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