摘要:
selecthouseid,projname,city,room,hall,toilet,kitchen,buildingarea,livingarea,price,prividerfrom(select*,Row_Number()OVER(ORDERBYregistdatedesc)asrownumfrom(selecttop16600houseid,registdatefromCOMMERCE_lease_BJ_mlsasa(nolock)where1=1andcity='北京'andpurpose='写字楼'orderbyregistdatedesc)a) 阅读全文
posted @ 2009-11-02 16:41 yuanws 阅读(159) 评论(0) 推荐(1) 编辑