Android的SQL - 你怎么按多列排序您的SQL查询 [英] android sql - how do you order your sql query by multiple columns

问题描述

我目前工作在Eclipse中的Andr​​oid项目，我有问题，我的SQL查询。

I am currently working on an Android project in Eclipse and i am having problems with my SQL query.

我想订购超过两列的查询，目前我对KEY_DAY_ID这样做，但我想通过KEY_START_TIME也做到这一点，但我不能让它的工作。

I am trying to order the query by more than two columns, currently i am doing it by KEY_DAY_ID but i want to also do it by KEY_START_TIME, but i can't get it to work

我的查询目前看起来是这样的：

my query currently looks like this:

Cursor cursor = db.query(TABLE_SESSION, new String[] {KEY_ID, KEY_MODULE_CODE, 
            KEY_DAY_OF_WEEK, KEY_START_TIME, KEY_DURATION, KEY_SESSION_TYPE, KEY_ROOM},
            null, null, null, null, KEY_DAY_ID  + " ASC");

请让我知道你的想法。预先感谢您！

Please let me know your thoughts. Thank you in advance!

推荐答案

在db.query的最后一个参数（）方法是order by子句中（不带ORDER BY）。所有你需要做的是独立的两列用，。因此，它看起来像：

The last parameter in db.query() method is the order by clause (without the "order by"). All you need to do is separate both columns by a ",". So it would look like:

Cursor cursor = db.query(TABLE_SESSION, new String[] {KEY_ID, KEY_MODULE_CODE, 
        KEY_DAY_OF_WEEK, KEY_START_TIME, KEY_DURATION, KEY_SESSION_TYPE, KEY_ROOM},
        null, null, null, null, KEY_DAY_ID + " ASC, " + KEY_START_TIME  + " ASC");

这篇关于Android的SQL - 你怎么按多列排序您的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！