select m.*
from
(
select a,b from tb group by a,b order by a,b
) as m消息 1033,级别 15,状态 1,第 7 行
除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
表如下
a b
1 a
1 b希望得到结果是
1 a
1 b
from
(
select a,b from tb group by a,b order by a,b
) as m消息 1033,级别 15,状态 1,第 7 行
除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
表如下
a b
1 a
1 b希望得到结果是
1 a
1 b
from
(
select a,b from tb order by a,b
)m 试试这么写~
select a,b from tb group by a,b order by a,b
--这样做不行吗
select
(select c from tb2
where tb2.a=m.a and tb2.b=m.b
) as Field1
from
(
select a,b from tb group by a,b order by a,b
) as m
1 1 ha
1 1 haha
2 1 ji
2 1 jiji
那个视图 要获取
1 1
2 1 而不是
1 1
1 1
2 1
2 1
select m.*
from
(
select top 100 percent a,b from tb group by a,b order by a,b
) as m