日期:2014-05-19 浏览次数:20871 次
<select id="showMy" parameterClass="dto" resultClass="dto"> SELECT [UserId] as userId ,(select top(1)expname from expset where abc.[exp]<=exptotal order by exptotal) as expName FROM [abc] where userid=#userId# </select>