Shulou(Shulou.com)05/31 Report--

This article is about how SQL implements JPQL sorting. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

jpql sort in ascending order, and null is last, you can use the COALESCE function to indicate that the first field is empty

take the maximum value of the latter,

In pure sql runtime, you can write order by field is null, field asc can be

Thank you for reading! About "sql how to achieve jpql sort" this article is shared here, I hope the above content can have some help for everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

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.