select* from (SELECT top 5 [rowid]
,CONVERT(nvarchar(8), [mdate],114)as mtime
,[mno]
,[tno]
,[mdate]
,[sno]
,[uno]
,[lno]
FROM [webtest].[dbo].[temp_data] order by [mdate] desc) as t order by [mdate] asc
沒有留言:
張貼留言