Tuesday, January 3, 2017

Numbering the result set records in mysql (oracle like ROWNUM)

Here's a nice stackoverflow answer as to how to display row numbers in a mySql query. (I am perplexed how is this a missing feature both in mySql Workbench and in the proprietary sqlYog).

Seems you can declare variables within queries and use them, on the fly. You may need, this, someday.

No comments:

Post a Comment