Teradata SQL Reference
Difference between TOP and SAMPLE in Teradata SQL?
We can find the difference clearly while using ORDER by clause.
Eg:- Select TOP 10 cust_name from customer order by dept_id;
TOP displays the first 10 rows in Sorted order from the table.
SAMPLE displays any 10 rows randomly from the table.
Tweet
3 comments:
Anonymous
October 18, 2013 at 8:08 PM
Which is faster sample or top command ?
Reply
Delete
Replies
Anonymous
August 31, 2014 at 11:21 PM
I guess it is explanatory
Delete
Replies
Reply
Reply
Unknown
September 29, 2014 at 3:01 AM
TOP command is faster than SAMPLE
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Which is faster sample or top command ?
ReplyDeleteI guess it is explanatory
DeleteTOP command is faster than SAMPLE
ReplyDelete