原始表
[img]http://dl2.iteye.com/upload/attachment/0115/9345/5ea439fb-7800-3faa-8006-42d8ee808b8e.png[/img]
查询语句
[img]http://dl2.iteye.com/upload/attachment/0115/9347/1ec198eb-f33f-3980-a11e-5ac1b719d047.png[/img]
查询结果
[img]http://dl2.iteye.com/upload/attachment/0115/9349/a44a2ff2-334d-3035-9138-39a33ed2fb97.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0115/9345/5ea439fb-7800-3faa-8006-42d8ee808b8e.png[/img]
查询语句
[img]http://dl2.iteye.com/upload/attachment/0115/9347/1ec198eb-f33f-3980-a11e-5ac1b719d047.png[/img]
查询结果
[img]http://dl2.iteye.com/upload/attachment/0115/9349/a44a2ff2-334d-3035-9138-39a33ed2fb97.png[/img]