Archives of the TeradataForum

Message Posted: Thu, 19 Dec 2013 @ 10:40:13 GMT

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

As far as I know, we can't use where clause:

     SELECT AND CONSUME TOP 1 col_1_qits, USER, CURRENT_TIMESTAMP FROM myqueue;

I have not implemented this feature. However with my two cents, I am thinking , I will manipulate my inserts, since I take the top.

Please share your experience.

Cheers,

Raja

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