摘要: SELECT * FROM ( SELECT * ,RANK() OVER(ORDER BY who_answ) c2 FROM Ft_Question ) b WHERE b.c2 IN ( SELECT a.c1 FROM ... 阅读全文
posted @ 2008-11-04 14:53 昕友软件开发 阅读(279) 评论(0) 推荐(0) 编辑
摘要: SELECT ROW_NUMBER() OVER (ORDER BY id DESC) AS rownum, * FROM ft_question ORDER BY id DESC 阅读全文
posted @ 2008-11-04 14:53 昕友软件开发 阅读(477) 评论(0) 推荐(0) 编辑
欢迎访问我的开源项目:xyIM企业即时通讯