use order by keyword in sql server querries

use order by function in your sql server query. Here i am giving you brief description about order by function.
demo database:

1] select all users order by their cities

2] select all user_name in ascending order.

3] select all users cities in descending order:

4] select all users order by user name and user cities.