oracle 按照时间倒序_关于oracle中按时间排序问题，请教！！急!!!

一张表noteid(主键)notecontentcontentidmobilelastmodifytime1...1...2011-10-0800:01:232...1...2011-10-0800:02:233...1...2011-10-0800:03:234...2...2011-10-0800:04:235...2......

一张表

noteid(主键) notecontent contentid mobile lastmodifytime

1 ... 1 ... 2011-10-08 00:01:23

2 ... 1 ... 2011-10-08 00:02:23

3 ... 1 ... 2011-10-08 00:03:23

4 ... 2 ... 2011-10-08 00:04:23

5 ... 2 ... 2011-10-08 00:05:23

6 ... 2 ... 2011-10-08 00:06:23

7 ... 3 ... 2011-10-08 00:07:23

8 ... 3 ... 2011-10-08 00:08:23

9 ... 3 ... 2011-10-08 00:09:23

10 ... 4 ... 2011-10-08 00:10:23

。。。。

现在要按照这样排序

10 ... 4 ... 2011-10-08 00:10:23

9 ... 3 ... 2011-10-08 00:09:23

6 ... 2 ... 2011-10-08 00:06:23

3 ... 1 ... 2011-10-08 00:03:23

sql该怎么写？即每个contentid中取最后更新的，然后再按时间排序。相同contentid只取一次。。。最新更新的放前面。

展开