SQL疑难杂症

Question

数据库 数据
b7122002 N          1          2011-10-13 10:24:23
b7123013 P          2        2011-10-13 09:11:52
b7122901 K          1         2011-10-13 09:11:54
b7122401 OM         2        2011-10-13 13:56:12
b7122012 pH         2.25        2011-10-13 09:11:58
17122002 N          1          2011-10-13 10:24:23
17123013 P          2         2011-10-13 09:11:52
17122901 K          3.5         2011-10-13 09:11:54
17122401 OM         4.6        2011-10-13 13:56:12
17122012 pH         5.8         2011-10-13 09:11:58效果
编号 类型 jg 日期1  编号1 类型1 jg1 日期1 编号2 类型2 jg2 日期2   编号3 类型3 jg3 日期3 编号4 类型4 jg4 日期4b7122002 N          1          2011-10-13 10:24:23 b7123013 P          2        2011-10-13 09:11:52 b7122901 K          1         2011-10-13 09:11:54 b7122401 OM         2        2011-10-13 13:56:12 b7122012 pH         2.25        2011-10-13 09:11:5817122002 N          1          2011-10-13 10:24:23 17123013 P          2         2011-10-13 09:11:52 17122901 K          3.5         2011-10-13 09:11:54 17122401 OM         4.6        2011-10-13 13:56:12 17122012 pH         5.8         2011-10-13 09:11:58