日期:2014-05-19 浏览次数:21043 次
<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>