从 sqlite 数据库中获取根据价格升序排序的数据

Question

"SELECT * FROM " + PRO_TABLE + " WHERE "
                + PRO_CATID + "= '" + cat_id + "' " +" AND "+ PRO_CAT + "= '" + cat_name + "' " + " AND "
                + PRO_SUB_CATID + "= '" + subcat_id + "' ORDER BY "+ PRO_PP + " ASC ";

Answer 1

你应该使用 CAST。

ORDER BY CAST(PRO_PP AS REAL) ASC