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 --点击率游客