sql hive

Select top N records in SQL / Hive

event 2019-11-18 thumb_up 0 visibility 22,280 comment 0 insights

more_vert

warning Please login first to view stats information.

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.

Code snippet

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

In Hive, use LIMIT N retrieve N records from the table. Remember to change N to an actual number.

Code snippet

SELECT * FROM TableName LIMIT N;

info Last modified by Raymond 6 years ago copyright This page is subject to Site terms.

Select top N records in SQL / Hive

insights Stats

Code snippet

Log in with external accounts

Select top N records in SQL / Hive

insights Stats

Table of contents

Code snippet

Log in with external accounts