Select Top 10 records

Tools & Utilities
Enthusiast

Select Top 10 records

hello folks, trying to perform the following

SELECT TOP 10 call_session_id
FROM etlbase.vivr_call_dtl

to get the top 10 records of the table. However, I get the following error:

3706: Syntax error: expected something between the word ‘TOP’ and the integer ‘10’.

Any clues?

when I look into the Teradata manual it should work... butttttt
2 REPLIES
Junior Contributor

Re: Select Top 10 records

Hi Vincent,
TOP syntax was implemented in V2R6 :-)

Dieter
Enthusiast

Re: Select Top 10 records

try with Rank function