如何从一个大数据库中获取数据然后分别进行对应的操作
1个回答
展开全部
如何从一个大数据库中获取数据然后分别进行对应的操作
SELECT ?,?,? FROM 表名 WHERE 条件 ORDER BY 要排序的字段 <a href="https://www.baidu.com/s?wd=ASC&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPvnsPvcvn1TsPvfvmHP90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnWcsnW61PHRvnHmzPH0krj0zr0" target="_blank" class="baidu-highlight">ASC</a>;
//<a href="https://www.baidu.com/s?wd=ASC&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPvnsPvcvn1TsPvfvmHP90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnWcsnW61PHRvnHmzPH0krj0zr0" target="_blank" class="baidu-highlight">ASC</a>是升序，也就是从小到大
//DESC是降序，从大到小
SELECT ?,?,? FROM 表名 WHERE 条件 ORDER BY 要排序的字段 <a href="https://www.baidu.com/s?wd=ASC&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPvnsPvcvn1TsPvfvmHP90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnWcsnW61PHRvnHmzPH0krj0zr0" target="_blank" class="baidu-highlight">ASC</a>;
//<a href="https://www.baidu.com/s?wd=ASC&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPvnsPvcvn1TsPvfvmHP90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnWcsnW61PHRvnHmzPH0krj0zr0" target="_blank" class="baidu-highlight">ASC</a>是升序，也就是从小到大
//DESC是降序，从大到小
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
