Displaying row count

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Displaying row count

David Fletcher
Hi all,

Is there a mode in the sqlite shell, or some fancy extension, that will
display a row
number when outputting results?  You know, something like this:

     sqlite> .row on
     sqlite> select * from SomeTable where ... ;
     1. a|17|93|...
     2. b|212|104|...

I tend to use the sqlite shell for debugging new queries and seeing a row
number would save me from always doing a 'select count(*) from (...
previous select ...)'


sqlite-users mailing list
[hidden email]