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

This article shows you how to achieve multi-condition and multi-field sorting in sql, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Statement: the copy code is as follows: select * from [User] order by [Password] desc,Id asc

In the case of a duplicate condition, the sort using the second condition is as follows:

Notice the statement of item 14 and 15 (sorted by Id in the case of the same Password): the copy code is as follows: select top (5) * from (select top (5) * from [User] order by Id desc) x order by [Password] asc

Sort in the data that has been queried (sorted) (that is, select Id to sort the first five records and then sort the five records according to Password) the copy code is as follows: select top (5) * from [User] order by Id desc

As follows

The copy code is as follows: select top (5) * from (select top (5) * from [User] order by Id desc) x order by [Password] asc

As follows:

Make an address book today, because the customer's requirements are complicated, alas. For multi-self conditional sorting, I found some information on the Internet and succeeded. Write down the copy code as follows: select * from Reply where Replyid= "& request (" Replyid ") &" order by sorting field 1 desc, sorting field 2 desc, sorting field 3 desc.

The above is how to achieve multi-conditional and multi-field sorting in sql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.