最新推荐文章于 2023-04-07 16:45:12 发布

转载最新推荐文章于 2023-04-07 16:45:12 发布 · 572 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/mr-hu2009/p/11578298.html

本文介绍了一种在SQL中使用字符串拼接功能来组合ID和标题的方法，通过具体实例展示了如何在查询中嵌套子查询以获取前后记录的ID和标题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--- 使用字符串拼接id，title
SELECT
    *,
    before = ( SELECT TOP 1 (convert(varchar(36),ContentId)+'|'+Title) as aa FROM Cms_Content WHERE CreateDate > ( SELECT CreateDate FROM Cms_Content WHERE ContentId = 'E1E75C65-AD85-4DC5-A74A-AE0892BABA38' )and Status = 1 and IsDelete = 0  ORDER BY CreateDate ),
    after = ( SELECT TOP 1 (convert(varchar(36),ContentId)+'|'+Title) FROM Cms_Content WHERE CreateDate < ( SELECT CreateDate FROM Cms_Content WHERE ContentId = 'E1E75C65-AD85-4DC5-A74A-AE0892BABA38' )and Status = 1 and IsDelete = 0  ORDER BY CreateDate DESC )
FROM
    Cms_Content 
WHERE
    ContentId = 'E1E75C65-AD85-4DC5-A74A-AE0892BABA38' and Status = 1 and IsDelete = 0

转载于:https://www.cnblogs.com/mr-hu2009/p/11578298.html