如何使用游标在MySQL中获取前两个记录
如何使用游标在MySQL中获取前两个记录
提问于 2022-05-17 09:45:34
在我的表中，我有包含'，‘的记录s。
Id Name
1 Here is the result
2 of your examination.
3 ,
4 New Opening for the position of
5 PT Teacher, Science Lab.
6 , 因此，在游标中，如果我找到'，‘，那么我想要将2行值合并到第一个。
DECLARE @ID int
DECLARE @Name nvarchar(500)
DECLARE MergeCursor CURSOR FOR
select ID,NAME from TEST_TABLE
OPEN MergeCursor
FETCH NEXT FROM NarrationCursor into @ID,@NAME
WHILE (@@FETCH_STATUS=0)
BEGIN
if(@Name = ',')
select * from TEST_TABLE where ID = (select max(ID) from TEST_TABLE where ID < @ID)
FETCH NEXT FROM NarrationCursor into @ID,@NAME
END
CLOSE MergeCursor
DEALLOCATE MergeCursor如何获得前两行，更新第1行中的值，并删除第2行和第3行。以及更新ID
最后，我想输出
Id Name
1 Here is the result of your examination.
2 New Opening for the position of PT Teacher, Science Lab. 回答 1
Stack Overflow用户
回答已采纳
发布于 2022-05-17 10:01:07
WITH
grouped AS
(
SELECT
SUM(CASE WHEN name=',' THEN 1 ELSE 0 END)
OVER (ORDER BY id)
AS group_id,
id,
name
FROM
TEST_TABLE
)
SELECT
group_id + 1 AS id,
STRING_AGG(name, ' ') WITHIN GROUP (ORDER BY id) AS name
FROM
grouped
WHERE
name <> ','
GROUP BY
group_id
ORDER BY
group_id页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/72271700
复制相关文章
相似问题
腾讯云开发者
