original.sql

SELECT 반환될_채팅_메시지_정보 FROM (
    SELECT TOP(50) 채팅_메시지_정보
    FROM [채팅_메시지_테이블] AS [c]
    WHERE [c].[채팅방_ID] = (찾을_채팅방_ID)
    ORDER BY [c].[전송_시각] DESC
) AS [t]
LEFT JOIN [채팅방_참여자_정보] AS [c0] ON [t].[채팅방_참여자_정보_ID] = [c0].[Id]
ORDER BY [t].[전송_시각] DESC