Select top N records in SQL / Hive

Raymond Tang Raymond Tang 0 22940 10.28 index 5/27/2019

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;
hive sql

Join the Discussion

View or add your thoughts below

Comments