SQL查询子串 [英] SQL query for substring

问题描述

朋友，我有一个带有两列示例的表:表名称:Code_Project
列名称:Id，Name

ID名称
20101234 A
20101235 B
20101236 C
20111234 D
20111235 E
20111236 F
20121234 G
20121235 H
20131234 J

我需要遵循以下输出
ID Count_id
2010 3
2011 3
2012 2
2013 1

我有一个查询

Hi friends I have a table with two column example: Table Name:Code_Project
Column Name: Id,Name

ID Name
20101234 A
20101235 B
20101236 C
20111234 D
20111235 E
20111236 F
20121234 G
20121235 H
20131234 J

I need Output as Follows
ID Count_id
2010 3
2011 3
2012 2
2013 1

I Have one query

select   substring(Id,1,4) as Id,count(Id) as count_id from Code_Project group by Id

在这里，我是另外一个人....

here i am separate count....

推荐答案

您几乎明白了；但在逐级调整时很少.

You almost got it; but little tweak at group by level.

select substring(Id,1,4) as Id,count(Id) as count_id from Code_Project group by substring(Id,1,4) 

这篇关于SQL查询子串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！