How to query only the top 10 rows in Redshift

Use the Top function to query only the top 10 rows. Syntax is as below:

Select top 10 * from schemaname.tablename order by columnname desc;

To view any 10 rows of a table:

Select top 10 * from schemaname.tablename;
or
Select * from schemaname.tablename limit 10;

See also  How to keep the folder and delete all contents of an S3 bucket prefix