问题描述
我很难过,我的大脑都被炸了!!!!
我有以下数据
+ ------- + ------------------------------ + ------------ +
| 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
---------------------------------------------------------------
这篇关于返回唯一记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!