摘要：
select left(songno,3) as songno from song //截取前3位select distinct right(left(songno,6),3) as Files from song order by Files asc // 截取中间select right(songno,6) as 歌曲编号 from song //截取后3位select left(songno,3) as 服务器编号 from songselect mapping from driversselect left(songno,3) as songno,drivers.mapping f.. 阅读全文
