返回唯一记录

扫码查看
本文介绍了返回唯一记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我很难过,我的大脑都被炸了!!!!


我有以下数据

+ ------- + ------------------------------ + ------------ +

| resID | FLEName | VersionNbr |

+ ------- + ------------------------------ + ------------ +

| 1 | 35_laserdatandria2104.zip | 1.0 |

| 2 | 35_laserdatandria2104 [1] .zip | 1.23 |

| 3 | 35_microweb1.31.zip | 1.0 |

| 4 | 35_microweb1.31 [1] .zip | 1.234 |

| 5 | 35_microweb1.31 [2] .zip | 1.345 |

| 6 | 35_microweb1.31 [3] .zip | 1.456 |

+ ------- + ------------------------------ + ------------ +


我需要能够只返回resID 2和6.


有人可以给我任何指示吗?


非常感谢

---------------- -----------------------------------------------
:脱掉裤子回复

---------------------------------------------- -----------------

解决方案




从yourtablename中选择resID,其中resID在(2,6);





对不起,我应该更清楚我的帖子(我做的是我的大脑是

scambled LOL)。


我需要检索最高版本号和/或lates文件

即myfile [3]。 zip。

---------------------------------------- -----------------------
:脱掉裤子回复

-------------------- -------------------------------------------

I''m stumped and my brains are fried!!!!

I have the following data
+-------+------------------------------+------------+
| resID | FLEName | VersionNbr |
+-------+------------------------------+------------+
| 1 | 35_laserdatandria2104.zip | 1.0 |
| 2 | 35_laserdatandria2104[1].zip | 1.23 |
| 3 | 35_microweb1.31.zip | 1.0 |
| 4 | 35_microweb1.31[1].zip | 1.234 |
| 5 | 35_microweb1.31[2].zip | 1.345 |
| 6 | 35_microweb1.31[3].zip | 1.456 |
+-------+------------------------------+------------+

I need to be able to return only resID 2 and 6.

Can anybody give me any directions on how to do this?

Many thanks
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

解决方案



select resID from yourtablename where resID in(2,6);





Sorry, I should''ve been clearer in my posting (I did sa my brains were
scambled LOL ).

I need to retrieve the highest version number and/or the lates file
i.e. myfile[3].zip.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------


这篇关于返回唯一记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-18 17:13
查看更多