按日期排序明智的报告？

本文介绍了按日期排序明智的报告？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 - 按日期排序报告问题 选择 liftingbirds，totalweight，avgweight，dcno， convert （ varchar ，liftingdate， 103 ） as liftingdate 来自 k_LiftingEntryRecords 其中 dcno = @ dcno 订单 按 liftdate desc 这里我没有得到订单明智的日期报告...当我删除条件dcno = @dcno，然后是订单明智的日期报告... 选择 liftingbirds，totalweight， avgweight，dcno， convert （ varchar ，liftingdate， 103 ） as liftingdate from k_LiftingEntryRecords 订单 按 liftingdate desc 其他明智的是它不来......比如解决方案 -- Order by date wise report problemselect liftingbirds, totalweight, avgweight, dcno, convert(varchar,liftingdate,103) as liftingdatefrom k_LiftingEntryRecordswhere dcno = @dcnoorder by liftingdate descHere I am not getting order wise date report ...when I remove where condition dcno = @dcno, then it comes order wise date report...select liftingbirds, totalweight, avgweight, dcno, convert(varchar,liftingdate,103) as liftingdatefrom k_LiftingEntryRecordsorder by liftingdate descother wise it's not come.. like 解决方案 这篇关于按日期排序明智的报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！