SELECT DISTINCT A.ID FROM TBL_FOO A where A._TIME >1340031599000 AND A._TIME=(SELECT MAX(_TIME) FROM TBL_FOO B WHERE B.ID =A.ID) order by A.VALUE DESC limit 5
...全文
24215打赏收藏
从一堆数据中,查出最近一段时间内最新的且值最大的5条数据,你有更好的办法吗?
SELECT DISTINCT A.ID FROM TBL_FOO A where A._TIME >1340031599000 AND A._TIME=(SELECT MAX(_TIME) FROM TBL_FOO B WHERE B.ID =A.ID) order by A.VALUE DESC limit 5
查询语句,表数据要求支持百万以上
SELECT DISTINCT A.RESOURCE_ID AS _VALUE FROM TBL_PM_LUN20120619 A WHERE 1=(SELECT COUNT(RESOURCE_ID) FROM TBL_PM_LUN20120619 B WHERE B.RESOURCE_ID IN('b2d89dcee0ec4852851eaccd7b338d7c','ede6b70ef6074081bf86fe0d3c9e38f0') AND A.RESOURCE_ID=B.RESOURCE_ID AND A.INDECATED_TIME <= B.INDECATED_TIME AND B.INDECATED_TIME >=1340081999000 AND B.INDECATED_TIME <=1340089199000) order by A.UTILIZATION DESC limit 1