How to write SQL statement to do such query?

Hi! dear all, (BI encountered a problem with designing SQL statement. For example, I (Bwant to query population information from a "city" table, and the (Brecords returned must be ordered according to the population of the (Bcity. Like this:

Re: How to write SQL statement to do such query?

SQL My wrote: (B (B Hi! dear all, (B I encountered a problem with designing SQL statement. For example, I (B want to query population information from a "city" table, and the (B records returned must be ordered according to the population of the (B city. Like this: (B