How to change/move the position of indicator to the first,last,next,previous row in sqlite3_stmt *pStmt

I'm use sqlite3_step() to fetch all rows in the sqlite database.

But the problem is how to move/change the indicator which in sqlite3_stmt *pStmt to moving between next row and previous row, or move to first row and last row.

I want the idea to do that ?