请用sql server2016语句截取fpath中第二个/和第三个/之间的字段
时间: 2023-03-14 15:35:01 浏览: 66
SELECT SUBSTRING(fpath, CHARINDEX('/', fpath, 1)+1, CHARINDEX('/', fpath, CHARINDEX('/', fpath, 1)+1)-CHARINDEX('/', fpath, 1)-1) AS 'Second Field' FROM your_table;
相关问题
请用sql server2016语句统计fpath中截取第二个/和第三个/之间的字段
SELECT SUBSTRING(fpath, CHARINDEX('/',fpath,1) + 1, CHARINDEX('/',fpath,CHARINDEX('/',fpath,1) + 1) - CHARINDEX('/',fpath,1) - 1) FROM TableName;
请用sql server语句统计fpath中截取第二个/后的字段
SELECT SUBSTRING(fpath,CHARINDEX('/',fpath,CHARINDEX('/',fpath)+1)+1,LEN(fpath)-CHARINDEX('/',fpath,CHARINDEX('/',fpath)+1)) AS field FROM TableName;