摘要: create table tb(id int, value varchar(10))insert into tb values(1, 'aa')insert into tb values(1, 'bb')insert into tb values(2, 'aaa')insert into tb values(2, 'bbb')insert into tb values(2, 'ccc')go-- 查询处理SELECT * FROM(SELECT DISTINCT id FROM tb)A OUTER APPLY( 阅读全文
posted @ 2013-06-09 16:39 GLenn-Cui 阅读(152) 评论(0) 推荐(0) 编辑