sql查詢結(jié)果按條件排序 數(shù)據(jù)庫查詢時(shí)怎么按照多個(gè)字段進(jìn)行排序?
數(shù)據(jù)庫查詢時(shí)怎么按照多個(gè)字段進(jìn)行排序?SQL使用order by sortselect*從表order by value1,Value2根據(jù)字段value1和Value2,默認(rèn)為升序select*從表
數(shù)據(jù)庫查詢時(shí)怎么按照多個(gè)字段進(jìn)行排序?
SQL使用order by sortselect*從表order by value1,Value2根據(jù)字段value1和Value2,默認(rèn)為升序select*從表order by value1,Value2 desc根據(jù)降序
查詢ID(表字段)=ID(參數(shù)值)在num(表字段)排序后,消息表中的數(shù)據(jù)