Hi..

Below is sample of my data:-
E1234
C1234
X1234
Z1234
S1234
B1234

Based on data, how could i selct first and last row of the data ?. The resuler must be:-
First row: E1234
Last row: B1234

I have tried used max and min query but it will be sort the data A-Z.

Please advise..

Thank you,
Baharin

no can do, sorry

What determines the order of the rows presented?

Since rows in a table have no inherant order, we can assume any order so just select the first two rows, the min and max values, the last two rows, or anything else that is convenient. If you want to put some specific order on the rows, then things are a little trickier, but no big deal.

-PatP

As Pat P says you need to establish what makes the earliest row and what makes the latest row. so whatever it is (and I'm expecting its going to be a another column... probably some for of date/time or batch + sequence ID)