问个简答的问题。 我怎么高效查询 orderbook 表里面timestamp.second == 5 的所有记录? 00:00:05, 00:01:05 00:02:05
select * from tick where timestamp.second ==5?
有个secondOfMinute得到秒数,比如:
select * from tick where secondOfMinute( timestamp) ==5