Select top 2 rows in Hive December 10, 2023 by Tarik Yes, here you can use LIMIT. You can try it by the below query: SELECT * FROM employee_list SORT BY salary DESC LIMIT 2