Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from (select * from t1 where id=14 order by timestamp desc) as h group by hnumber order by timestamp desc limit 0, 15
- select m from (select n from t1 n where n.id=:id order by timestamp desc) as m group by hnumber order by timestamp desc limit 0, 15
- seq
- id
- message
- timestamp
- hnumber
- Seq id message timestamp hnumber
- 1001 14 xyz1 1394607463000 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1002 14 xyz2 1394608378000 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1003 14 xyz1 1394453678000 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1004 14 xyz2 1394608520000 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1005 14 xyz9 1394612791000 369d7cf7bd90fac78ef635b188e2a9952d77a8d1
- 1006 14 xyz7 1394608513793 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1008 14 xyz6 1394608513793 0429c3866c19981fc276855ff3cdaf100e0c9fdb
- 1009 14 xyz3 1394622221000 369d7cf7bd90fac78ef635b188e2a9952d77a8d1
- 1010 14 xyz4 1394608513793 369d7cf7bd90fac78ef635b188e2a9952d77a8d1
- Seq id message timestamp hnumber
- 1009 14 xyz3 1394622221000 369d7cf7bd90fac78ef635b188e2a9952d77a8d1
- 1004 14 xyz2 1394608520000 0429c3866c19981fc276855ff3cdaf100e0c9fdb
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement