Teradata Material
Pages
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
Monday 10 March 2014
How to select first N Records in Teradata?
Answers:
To select N records in Teradata you can use RANK function. Query syntax would be as follows
SELECT BOOK_NAME, BOOK_COUNT, RANK(BOOK_COUNT) A FROM LIBRARY QUALIFY A <= 10;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment