select count(*) from (select distinct singer from songsource) a
select count(*) as 数量 from (select distinct singer from songsource) a
只返回数量?没明天你的意思。 select cast(count(*) as varchar)+'个不同歌手' from (distinct singer from songsource)b
select singer,count(singer) from songsource group by singer
select singer,count(singer) from songsource group by singer 跟select singer,count(*) from songsource group by singer 一样呀。 真不知道怎么才满足楼主的要求。
select singer, count(*) as songcount from songsource group by singer
返回歌手数量 select count(*) as 歌手数 from (select distinct singer from songsource) temp返回各歌手及对应的歌曲数 select singer, count(*) as songcount from songsource group by singer
罗列各歌手.最后加合计人数行 select distinct singer from songsource union select count(*) from (select distinct singer from songsource) temp order by singer desc
select sum(1) as 歌手数 from (select distinct singer from songsource) temp
(select distinct singer from songsource) a
(select distinct singer from songsource) a
select cast(count(*) as varchar)+'个不同歌手' from (distinct singer from songsource)b
group by singer
group by singer
跟select singer,count(*) from songsource
group by singer
一样呀。
真不知道怎么才满足楼主的要求。
select count(*) as 歌手数 from
(select distinct singer from songsource) temp返回各歌手及对应的歌曲数
select singer, count(*) as songcount from songsource group by singer
select distinct singer from songsource
union
select count(*) from
(select distinct singer from songsource) temp
order by singer desc
(select distinct singer from songsource) temp