视图查询！！！急急！

Question

可不可以用distinct  来实现呢？

Answer 1

create view xxxxx
as
select regUserName,biditemid,max(bidAmount) as bidAmount
from tablename
where regUserName='aaaaaaa'
group by regUserName,biditemid
goor:create view xxxxx
as
select * from 
from tablename a
where regUserName='aaaaaaa'
and bidAmount=(select max(bidAmount) from tablename where regUserName='aaaaaaa' and biditemid=a.biditemid)
go

Answer 2

可不可以如此:
create view xxxxx
as
select regUserName,biditemid,max(bidAmount) as bidAmount
from tablename
where regUserName='aaaaaaa'
group by biditemid
go
我认为,剔除了biditemid的重复就可以了

Answer 3

select regUserName,biditemid,max(bidAmount) 
from  buy_view3
where regUserName='aaaaaaa'
group by regUserName,biditemid

Answer 4

create view xxxxx
as
select * from 
from tablename a
where regUserName='aaaaaaa'
and bidAmount=(select max(bidAmount) from tablename where regUserName='aaaaaaa' and biditemid=a.biditemid)
go