select top 6 * from music order by chick 这个是查询点击率的
现在的问题是 查询 只有会员点击率 会员列名 hy_chick 1是游客 2是会员
select top 6 * from music order by chick where...这里怎么写?
------解决方案--------------------
select top 6 * from music where hy_chick=2 order by chick
------解决方案--------------------
select top 6 * from music where hy_chick=2 order by chick
------解决方案--------------------
现在的问题是 查询 只有会员点击率 会员列名 hy_chick 1是游客 2是会员
select top 6 * from music order by chick where...这里怎么写?
-----------------
select top 6 * from music where hy_chick=2 order by chick --会员点击率
select top 6 * from music where hy_chick=1 order by chick --点击率游客