How To Select First N Records In Teradata?

1.	How To Select First N Records In Teradata?
Answer» 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; To select N records in Teradata you can use RANK function. Query syntax would be as follows

Answer»

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;

To select N records in Teradata you can use RANK function. Query syntax would be as follows

Discussion