mysql排序語句 升序 mysql order by默認是升序還是降序?
mysql order by默認是升序還是降序?sql的降序語句是什么?降序select*from KC order by cpbh desc升序select*from KC order by cpb
mysql order by默認是升序還是降序?
sql的降序語句是什么?
降序select*from KC order by cpbh desc升序select*from KC order by cpbh ASC實例:/*查詢student表,并按降序排序*/選擇name,student ID from studentsInformation order by studid desc/**按什么排序,默認為升序,desc為降序*/*查詢student表中前5名學(xué)生的姓名和學(xué)號,并按升序排列*/選擇前5名,studid from students信息順序按studid/*順序默認為升序*/