Qt Code:
  1. model->setQuery( "SELECT field1,field2 FROM table1" );
To copy to clipboard, switch view to plain text mode 
You are using not more than 1 table so QSqlTableModel fits your needs?

instead of
QSqlQueryModel *model = new QSqlQueryModel(tableView);
you could use
QSqlTableModel *model = new QSqlTableModel(tableView);
which has
void QSqlTableModel::sort ( int column, Qt::SortOrder order ) [virtual]
implemented

Cheers