What is MSSQL · order by 1 desc?

Time:2021-7-21
Reading time |0.05 min word count |95.2 characters
primary coverage |1. Introduction & background
“What is MSSQL · order by 1 desc?”
Author | SCscHero Writing time | 2021/7/19 PM11:5
Article type |Series Completion |Completed
motto Every great cause has a trivial beginning.

1、 Introduction & background    Completion: 100%


a) Coping with problems

How to write order by 1 desc?

b) Solution principle & method

Select * from [tablename] order by 1 desc // sort the first field in the table in reverse order. For example, the first field is the primary key autoincrement ID
Select name, * from [tablename] order by 1 desc // sort the first field in the table in reverse order, such as name

2、 Statement and references    Completion: 100%


Original blog, please do not reprint without permission.

If you have any help, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can directly send a private message to scscshero.