有一个表的内容如下:id htbh hkqc
id htbh hkqc
1 NO01 1
2 NO01 1
5 NO01 1
6 NO01 2
8 NO01 2
11 NO01 3
15 NO01 3
16 NO01 3现在想得到相同htbh和hkqc的最大id号的记录:
id htbh hkqc
5 NO01 1
8 NO01 2
16 NO01 3如何写SQL语句?
id htbh hkqc
1 NO01 1
2 NO01 1
5 NO01 1
6 NO01 2
8 NO01 2
11 NO01 3
15 NO01 3
16 NO01 3现在想得到相同htbh和hkqc的最大id号的记录:
id htbh hkqc
5 NO01 1
8 NO01 2
16 NO01 3如何写SQL语句?
1 NO01 1
2 NO01 1
5 NO01 1
6 NO01 2
8 NO01 2
11 NO01 3
15 NO01 3
16 NO01 3现在想得到相同htbh和hkqc的最大id号的记录:
id htbh hkqc
5 NO01 1
8 NO01 2
16 NO01 3如何写SQL语句?