Shulou(Shulou.com)06/01 Report--

Select * from products order by case when isTop=0 then 1 else 0 end,pId desc

I understand this sentence as follows:

IsTop=0 (set to 1) untopped = 1 topped (set to 0); arranged in ascending order.

PId is the primary key of the table, growing itself; sorting in descending order.

In this way, the descending and topping of the primary keys can be arranged in descending order.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.