How to show top 100 record from a table flights_2008_7M because rownum is not working in this
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