code和xgsj联合主键的记录取出xgsj最新的code,求sql语句，很有意思

code                        xgsj
1 10000000000000021356 2007-5-15 15:53:31
2 10000000000000021356 2007-5-15 15:52:34
3 10000000000000021358 2007-5-15 15:54:07
4 10000000000000021358 2007-5-15 15:53:31
5 10000000000000021360 2007-5-15 16:43:13
6 10000000000000021360 2007-5-15 15:54:07
7 10000000000000021762 2007-5-15 17:23:39
8 10000000000000021762 2007-5-15 17:07:26
9 10000000000000021813 2007-5-15 17:30:13
10 10000000000000021813 2007-5-15 17:23:47
11 10000000000000021907 2007-5-16 18:07:17
12 10000000000000021907 2007-5-16 18:03:04
13 10000000000000021907 2007-5-16 17:54:59
14 10000000000000021907 2007-5-16 17:48:13
15 10000000000000021907 2007-5-16 17:46:17
16 10000000000000021907 2007-5-16 17:44:30
17 10000000000000021907 2007-5-15 17:33:00
18 10000000000000022005 2007-5-16 19:04:11
19 10000000000000022006 2007-5-16 19:34:05
20 10000000000000022006 2007-5-16 19:07:51
像这种记录，出现code和xgsj联合主键，但是我需要将xgsj最新的code取出来，有没有sql语句能够解决呢？