where怎么写?

[zenter]

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

[chenzhuo]

select top 6 * from music where hy_chick=2 order by chick

[bill024]

select top 6 * from music where hy_chick=2 order by chick

[fa_ge]

现在的问题是 查询 只有会员点击率 会员列名 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 --点击率游客

[zenter]

谢谢 ~