怎样返回第一行？

Question

select top 1 GHIS.CDATE from GDRT                                                                               where @Time < convert(varchar(20),GHIS.CDATE,120) order by DATE ASC

Answer 1

declare VarCur1 cursor for select GHIS.CDATE from GDRT
                                                                               where @Time < convert(varchar(20),GHIS.CDATE,120) order by DATE ASC
                 open VarCur1
      fetch varcur1 into @NewTime
     select convert(varchar(20),@NewTime,120)
       close VarCur1
        deallocate VarCur1
           end