本文介绍了如何使用sql server区分多个列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
select distinct MRP.[date],FT.feedtype,round(MRP.rateperkg,3) as Rateperkg from
K_FS_FeedMrpDetails MRP inner join K_FPS_feedtype FT on FT.sno=MRP.feedtype
where MRP.[date] between '2013-08-09 00:00:00.000' and '2014-08-25 00:00:00.000' and
MRP.state = 1 and MRP.rateperkg != 0
group by ft.feedtype,mrp.rateperkg order by MRP.[date] desc
在我的查询中有相同的列值feedtype和rateperkg ..
现在我想区分这两列......我怎么能这样做?
请帮帮我
In my query has same column values feedtype and rateperkg..
Now i want to distinct the these two columns ...how can i do this?
Please help me
推荐答案
这篇关于如何使用sql server区分多个列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!