create procedure ProSelect_FixDateTable/*查询 FixDateTable*/
@GameGroundId varchar(50)
as
select MemberKaId,GameGroundId,YdStartTime,YdEndTime
from FixDateTable
where GameGroundId=@GameGroundId
group by MemberKaId,GameGroundId,YdStartTime,YdEndTime
GO我希望以 YdStartTime 的递增排序。各位大哥这要怎么写啊?谢谢!
@GameGroundId varchar(50)
as
select MemberKaId,GameGroundId,YdStartTime,YdEndTime
from FixDateTable
where GameGroundId=@GameGroundId
group by MemberKaId,GameGroundId,YdStartTime,YdEndTime
GO我希望以 YdStartTime 的递增排序。各位大哥这要怎么写啊?谢谢!
@GameGroundId varchar(50)
as
select MemberKaId,GameGroundId,YdStartTime,YdEndTime
from FixDateTable
where GameGroundId=@GameGroundId
group by MemberKaId,GameGroundId,YdStartTime,YdEndTime order by YdStartTime
GO--这样?