Hi,
If this is still pertinent, I have given it some thought and come up with a couple of suggestions, I would like to understand more of why you would need to do this, as well as see what you are attempting to achieve.
Anyhow, I put your values into a text file for the purposes of this, so I have a file called values.txt that looks like this;
0
5
8
9
6
4
8
6
3
4
9
2
I don't know why you would want the second to minimum value, if it is because you don't want the zero value, then you could do this;
logparser "select min(Text) from values.txt where to_int(Text) > 0"
Alternatively you can get the 2 lowest values like this;
logparser "select top 2 Text from values.txt order by Text asc"
I then tried to make this into a nested select where I could get the max of the top 2, but haven't come right with it as yet. Anyone else maybe got this kind of nested select right? Maybe something like "select max(top 2 Text) from values.txt order by Text asc" - I just can't get past the syntax at this stage.
What I did do is execute these two queries on one commandline to get what you wanted;
logparser -q:on "select top 2 Text from values.txt order by Text asc"|logparser "select max(Text) as Somfu from stdin"
A feature like the Oracle rownum would also work for you.
Hope this helps.
Cheers, Dave