create view sogou_view as select * from sogou_20111230 where rank <=3; show tables; select * from sogou_view limit 3; select count(distinct uid) from sogou_view;