#42 Add LIMIT option along side the WHERE option

[Niels Kristian]

In the export from section it could be very cool to just have a simple LIMIT option instead of only a WHERE clause.

Often what I need to do is just exporting a random 500 of samples from a table, instead of a specific filtered amount. Currently I have to come up with some query that does a filtering until I only have around 500 rows. This is very time consuming to guess and play around with.

Thanks

[Ralf Wisser]

Hi,
that would be indeed a nice feature!

OTOH, it is always possible to limit the number of subject rows by using a WHERE clause like

where T.<pk-column> in (select <pk-column> from <table> limit <n>)

for example, with the WHERE condition:

where T.empno in (select empno from employee limit 10)

only 10 employees will be exported.

[Niels Kristian]

Ah, didn't think of that, that's a clever move!