Display number of results at top of output, rather than bottom?

jupyter-xeus / xeus-sql

Jupyter kernel for SQL databases

https://xeus-sql.readthedocs.io/en/latest/

BSD 3-Clause "New" or "Revised" License

165 stars 22 forks source link

Display number of results at top of output, rather than bottom? #62

Closed jameshowison closed 10 months ago

jameshowison commented 2 years ago

When writing queries it's often useful to get a feel for the number of results (without specifically writing a COUNT(*) bit). Currently the number of rows is at the bottom which means lots of scrolling to see (for any decent size of results).

Could the number of results line come at the top? (That would also combine well with paging results :)

marimeireles commented 2 years ago

That's reasonable :)

marimeireles commented 1 year ago

This is also relatively simple... With an ugly solution but will work. You can filter count results and use STD to order the results.