Archives of the TeradataForum

Message Posted: Thu, 27 May 2010 @ 14:58:00 GMT

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

Experts,

"Qualify" is not working in my system. I am running a simple sql.

     select FIELD1 from TEST.TABLE1 qualify rank(FIELD 2) =1

I am getting the following error.

" 3706 : Synatax error : Expected something between 'QUALIFY' and ';'

Could you please help

Details of data database

     InfoKey                   InfoData
     -------                   --------
     LANGUAGE SUPPORT MODE     Standard
     RELEASE                   12.00.03.03
     VERSION                   12.00.03.01a

Thanks,

Prasad K K

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