|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/8/2008 9:02:52 AM
Posts: 2,
Visits: 4
|
|
Can you tell me what is equivallent
of rownum in teradata
in oracle I can use
select rownum,ename from emp
What is its equivalent query in teradata?
JACK
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 7/2/2008 3:11:56 PM
Posts: 40,
Visits: 87
|
|
hi jack,
I believe you want to use rownum to limit the number of rows retrieved. as far as i know, there is no system column in teradata to do this, but one can generate a column like a seq_num to retrieve specific interval of rows. if the order is not required, you can use SAMPLE to return a specific number of rows, though randomly.
sel * from this wil return 10 rows selected randomly.
thx,
-SN
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/25/2008 7:26:06 AM
Posts: 474,
Visits: 202
|
|
Hi Jack,
it's ROW_NUMBER() OVER (ORDER BY ...)
Btw, Oracle also supports that RW_NUMBER.
Dieter
|
|
|
|