Home  >  Article  >  Database  >  Looking for mysql master - mysql query method, please give guidance

Looking for mysql master - mysql query method, please give guidance

WBOY
WBOYOriginal
2016-07-06 13:28:32982browse

Mysql is asking mysql masters for sql query problems

Could you please tell me how I can use the select statement in the database to query the number of posts and then sort them from most to lowest.

Reply content:

1. Use Select statement
2. Specify conditions through where
3. Specify sorting through oreder by
4. Use DESC to specify the sorting method from most to least.

For example:
'select * From Elderly fee statistics where (ID number=' #39 S2 #39 ') and (year and month=' #39 DateS #39 ') order by ''Total'' DESC';
Sort the data in descending order in the "Total" field to display the data.

Please give me guidance c
Please give me guidance
Please give me guidance, I am a beginner
------------------------biu~biu ~biu~~~ Here is the question and answer robot Little D. This is the answer I gave based on my own intelligence. If it is incorrect, come and bite me!

select * from table order by asc;

SQL is Structured Query Language, and basically all syntax is related to query. I can’t answer you right now. You can read this e-book "Must Know and Must Know SQL",
Basically all sql languages ​​are basically the same, but they are different in terms of implementation details

You have to see what your data sheet looks like before you can write it out

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn