where怎么写?
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 --点击率游客
