如何对部分记录进行分组-t-sql [英] How to Group the partial records -t-sql

问题描述

我想为以下scnerio编写t-sql查询.

那里有40000条记录.

如何在-t-sql
中对部分匹配进行分组

考虑一下这是我的桌子.

Hi,

I want to write t-sql query for the below scnerio.

there 40000 records are there.

How to group the partial matching in - t-sql


Consider this is my table.

description	Code	Remarks
Some Desc.	100	
Some Desc.1	100.0	Some Desc Left
Some Desc.1	100.1	Some Desc Right
Some Desc.1	100.2	Some Desc Right Some Desc
Some Desc.1	100.3	Some Desc Left Some Desc
Some Desc.2	100.00	Some Desc with Two digit Left
Some Desc.2	100.01	Some Desc with Two digit right
Some Desc.2	100.02	Some Desc with Two digit Middle
Some Desc.2	100.03	Some Desc with Two digit Upper
Some Desc.3	100.000	Left Some Desc with Three digit 
Some Desc.3	100.001	right Some Desc with Three digit 
Some Desc.3	100.002	Middle Some Desc with Three digit
Some Desc.3	100.003	Upper Some Desc with Three digit

输出应为
================

Output should be
================

Category	Sub Category	code	Desc	               Sub Desc
Some Desc.		        100		
Some Desc.	Some Desc.1	100.0	Some Desc 	        Left
Some Desc.	Some Desc.1	100.1		                Right
Some Desc.	Some Desc.1	100.2		                Right Some Desc
Some Desc.	Some Desc.1	100.3		                Left some Desc
Some Desc.	Some Desc.2	100.00	Some Desc with Two digit Left
Some Desc.	Some Desc.2	100.01		                right
Some Desc.	Some Desc.2	100.02		                Middle
Some Desc.	Some Desc.2	100.03		                Upper
Some Desc.	Some Desc.3	100.000	Left 	                Some Desc with Three digit 
Some Desc.	Some Desc.3	100.001	right	
Some Desc.	Some Desc.3	100.002	Middle	
Some Desc.	Some Desc.3	100.003	Upper

推荐答案

T-SQL中有字符串混搭功能，您可以使用它们选择同一列的两个不同子字符串.您可以使用LIKE关键字查找"Some Desc"文本，仅在其上进行匹配.

There are string mashing functions in T-SQL, you can use them to select two different substrings of the same column. you can use the LIKE keyword to find your ''Some Desc'' text and only match on it.

这篇关于如何对部分记录进行分组-t-sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！