当前位置：网站首页>MySQL query specifies that a row is sorted to the first row

MySQL query specifies that a row is sorted to the first row

2022-04-23 03:18:00 【Pingshan CP3】

Demand background ： When querying , Specify the first row of a row in the query result , Just know the value of a column in this row . The default sort is ：

  Then now is the time to let course_code=1002 That row of records is in the first row of the query result ;

Implementation scheme ： stay order by The field specified in the is implemented for a specific value ：（ Both writing methods can be ）

  The principle is ,order by When ,course_code=1002 Boolean calculation is the value 1, For the other 0, You can sort it ;

expand ： If you specify multiple lines （ Specify multiple values ）

版权声明
本文为[Pingshan CP3]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220627117003.html

边栏推荐

猜你喜欢

随机推荐