Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2012 @ 14:09:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sathesh -- using a sub-select pull all the rows except the minimum. Then select the minimum from the sub-select set.

Alternatively, U can use the various ranking SQL techniques to select, rank, and pull the lowest 2, getting the desired row that way.

Rgrds,

Bill Gregg, Teradata

	<Prev	Next>		<<First	<Prev	Next>	Last>>