首页 > 数据库技术 > 详细

linux_shell_类似sql的orderby 取最大值

时间:2015-08-15 17:46:48      阅读:226      评论:0      收藏:0      [点我收藏+]
{"time":"2015.08.14 21:45:13","total":999224516}
{"time":"2015.08.14 21:45:24","total":999225424}
{"time":"2015.08.14 21:45:34","total":999226141}
{"time":"2015.08.14 21:45:47","total":999227249}
{"time":"2015.08.14 21:45:57","total":999228051}
{"time":"2015.08.14 21:50:08","total":999247950}
{"time":"2015.08.14 21:50:34","total":999249978}
{"time":"2015.08.14 21:50:58","total":999251893}
{"time":"2015.08.14 21:55:14","total":999271885}
{"time":"2015.08.14 21:55:26","total":999272904}

需求场景 ,通过shell 筛选 每分钟的最大一条输出(最后一条) :

awk -F"," BEGIN{line=""}{pre=substr(line,10,16);a=substr($1,10,16);if(line != "" && pre!=a){print line}line=$0} 5.info | head

 

linux_shell_类似sql的orderby 取最大值

原文:http://www.cnblogs.com/cphmvp/p/4732622.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!