Query Re listing Text column associated with number column

[StormWolf]

Hi All,

I have a query question. I can list the first and last number in a series using Min and Max, no probs, but my problem is to also list the associated text with the number. My setup is TableID, Series, Details. Running Min or Max with text gives the wrong result.

Thanks

[chrisb]

a self join is probably the most efficient solution.
replace the two instances of 'MyTable' with the name of your table:

Code: Select all

select t2.*
from
	(select min("Series") mn, max("Series") mx from "MyTable") t1
join
	(select "TableID", "Series", "Details" from "MyTable") t2
	on t1.mn = t2."Series" or t1.mx = t2."Series"