加上order by field 可以升序,也可以降序,如 select TABLENAME, FIELDNAME from querydict where field in ('BLOCKID','CARDID','NAME') order by field desc; 或 select TABLENAME, FIELDNAME from querydict where field in ('BLOCKID','CARDID','NAME') order by field asc;
select TABLENAME, FIELDNAME from querydict where field in ('BLOCKID','CARDID','NAME') order by field
上面的资料巧合:select TABLENAME, FIELDNAME from querydict where field in ('NAME','BLOCKID','CARDID') field ... NAME ... BLOCKID ... CARDID ... 这样怎么排?就是依照('NAME','BLOCKID','CARDID') 对记录进行排序
只需要order by field(升序) order by field desc(降序)
field ... NAME ... BLOCKID ... CARDID ... 这样怎么排?就是依照('NAME','BLOCKID','CARDID') 对记录进行排序 ------------------------------------------------------------------------------- 你这样很难处理啊,既不是升序也不是降序,为什么会需要这样的顺序呢
select TABLENAME, FIELDNAME from querydict
where field in ('BLOCKID','CARDID','NAME')
order by field desc;
或
select TABLENAME, FIELDNAME from querydict
where field in ('BLOCKID','CARDID','NAME')
order by field asc;
where field in ('BLOCKID','CARDID','NAME') order by field
where field in ('NAME','BLOCKID','CARDID') field ...
NAME ...
BLOCKID ...
CARDID ...
这样怎么排?就是依照('NAME','BLOCKID','CARDID')
对记录进行排序
order by field desc(降序)
NAME ...
BLOCKID ...
CARDID ...
这样怎么排?就是依照('NAME','BLOCKID','CARDID')
对记录进行排序
-------------------------------------------------------------------------------
你这样很难处理啊,既不是升序也不是降序,为什么会需要这样的顺序呢