sqlserver查询最接近的记录

select top 1 SEX,ACTIVE ,HEIGHT,WEIGHT,HOT,CARBON,PROTEIN,FAT,sodium from standard where sex='0'and active= 'D' order by abs(AGE-1), abs(HEIGHT-160), abs(WEIGHT-52)

posted @ 2018-01-23 18:09  baby孔祥超  阅读(202)  评论(0编辑  收藏  举报