KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to create a view that automatically adds virtual row number in the result. the graph here is totally random all that I want to achieve is the last column to be created dynamically. > +--------+------------+-----+ > | id | variety | num | > +--------+------------+-----+ > | 234 | fuji | 1 | > | 4356 | gala | 2 | > | 343245 | limbertwig | 3 | > | 224 | bing | 4 | > | 4545 | chelan | 5 | > | 3455 | navel | 6 | > | 4534345| valencia | 7 | > | 3451 | bartlett | 8 | > | 3452 | bradford | 9 | > +--------+------------+-----+ Query: SELECT id, variety, SOMEFUNCTIONTHATWOULDGENERATETHIS() AS num FROM mytable
Tags (comma-separated)
Save Edits
Cancel