how to get rowNum like column in sqlite IPHONE

by

The fake rownum solution is clever, but I am afraid it doesn’t scale well (for complex query you have to join and count on each row the number of row before current row).

I would consider using create table tmp as select /*your query*/.
because in the case of a create as select operation the rowid created when inserting
the rows is exactly what would be the rownum (a counter). It is specified by the SQLite doc.

Once the initial query has been inserted, you only need to query the tmp table:

select rowid, /* your columns */ from tmp
order by rowid

More Related Contents:

  1. how to save the data in sqlite3 in iphone
  2. SQLite Exception: SQLite Busy
  3. How get a datetime column in SQLite with Objective C
  4. Best Cocoa/Objective-C Wrapper Library for SQLite on iPhone [closed]
  5. My app working in iphone 5 but not in 3 why? [closed]
  6. Custom colors in UITabBar
  7. Is it true that one should not use NSLog() on production code?
  8. How can I get a precise time, for example in milliseconds in Objective-C?
  9. When do you make an underscore in front of an instance variable? [duplicate]
  10. program access to iPhone volume buttons
  11. Change iOS app’s language on the fly
  12. Autorotate in iOS 6 has strange behaviour
  13. Center text vertically in a UITextView
  14. How to resize the image programmatically in objective-c in iphone
  15. iPhone: Convert date string to a relative time stamp
  16. How to find the cause of a malloc “double free” error?
  17. UIView drag (image and text)
  18. create uibutton subclass
  19. How to give space between two cells in tableview?
  20. Warning: control reaches end of non-void function – iPhone
  21. Draw Graph curves with UIBezierPath
  22. How can you apply distortions to a UIImage using OpenGL ES?
  23. Is there any framework to highlight text on pdf file after rendering on the iphone
  24. What does the -ObjC linker flag do?
  25. Increment the Push notification Badge iPhone
  26. Getting UILabel to produce an ellipsis rather than shrinking the font
  27. QLPreviewController remove or add UIBarButtonItems
  28. NSDateFormatter and yyyy-MM-dd
  29. Why tack a protocol of NSObject to a protocol implementation
  30. How to detect UIKeyboard “backspace” button touch on UITextField? [duplicate]

Leave a Comment