![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5COmJWNlJGOxUjZkNDMyEWYmN2MxMTY3ATMhJjY2QWM58CX0EzLchDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjL1M3Lc9CX6MHc0RHaiojIsJye.png)
--SELECT stuid FROM dbo.BZList WHERE AreaOrganID=-1 AND AreaPointCode=-1 AND DeptOrganID=-1
SELECT bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode FROM dbo.BZList WHERE StuID =338180 ORDER BY BZDate
SELECT bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode FROM dbo.BZList WHERE StuID =338180 AND BZKTypeCode=202 ORDER BY BZDate
WITH rs
AS ( SELECT stuid AS n
FROM dbo.BZList
WHERE AreaOrganID = -1
AND AreaPointCode = -1
AND DeptOrganID = -1
)
SELECT
bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode,
ISNULL(( SELECT TOP 1
BZRemark
FROM dbo.BZList b2
WHERE b1.stuid=b2.stuid
AND BZKTypeName = '轉學'
AND b2.BZDate > b1.BZDate
), b1.PointCode)
FROM dbo.BZList b1
WHERE EXISTS ( SELECT TOP 1 1 FROM rs WHERE n = StuID )
ORDER BY stuid,b1.BZDate