Select Top 10 records
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Select Top 10 records Expand / Collapse
Author
Message
Posted 8/10/2006 2:48:03 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 2 days ago @ 1:34:40 PM
Posts: 35, Visits: 9
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


Vincent Gabrielli
Post #4874
Posted 8/14/2006 1:22:26 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 3:41:05 AM
Posts: 522, Visits: 264
Hi Vincent,
TOP syntax was implemented in V2R6 :-)

Dieter
Post #4894
Posted 8/17/2006 9:47:27 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/27/2008 11:31:18 AM
Posts: 19, Visits: 25
try with Rank function
Post #4924
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 5:12am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 7 queries. Compression Disabled.