Top 100 record from a table


How to show top 100 record from a table flights_2008_7M because rownum is not working in this


Hi @anumbhavj880,

You can just use a simple limit, like select * from flights_2008_7M limit 100;

(Of course in general we recommend avoiding select * queries since MapD as an analytic database is not necessarily optimized for this).

If you are looking for the equivalent of rownum it is rowid in MapD, as described here: Sequence number.



thanks for reply