![\"SQL](\"https:\/\/solutionsreview.com\/cloud-platforms\/files\/2016\/06\/SQL-Database-Hacks-Using-AS-and-ORDER-BY.jpg\")
<\/p>\n<\/p>\n
Morpheus Data’s<\/a> CTO, Brian Wheeler<\/a>, contributes with this SQL HowTo,\u00a0that\u00a0walks users through some advanced SQL hacks guaranteed\u00a0to save time if they use SQL regularly.\u00a0Morpheus<\/a>\u00a0allows users\u00a0to provision apps in a single click, and provides ease of use for developers with APIs and a CLI. Backups are automatic, and users\u00a0can have redundancy as needed to avoid potentially long waits for disaster recovery to take place.<\/p>\n By Brian Wheeler, CTO | Morpheus Data<\/p>\n When retrieving data from an SQL database, it is often handy to be able to reference a column name with a shorter or more meaningful name when you make use of the results. Also, many times it is very helpful if the results are ordered in ascending or descending order by the content of a particular column. These things can be done in an SQL query using AS and ORDER BY.<\/p>\n How to use AS<\/b><\/p>\n In SQL, the AS keyword can be used to make referencing a column easier. For example, you may be querying a table with one or more long column names, like the following table:<\/p>\n Table: orders<\/p>\n +—-+———————————- +———————————–+<\/p>\n | id | number_of_rocks_ordered | number_of_socks_ordered |<\/p>\n +—-+———————————–+———————————–+<\/p>\n | 1 | 2 | 1 |<\/p>\n | 2 | 3 | 3 |<\/p>\n +—-+———————————–+———————————–+<\/p>\n To make the column names easier to deal with in clauses, subqueries, or on the programming side, you can use AS in your query to provide a shorter alias to use later, as in the following example:<\/p>\n SELECT id, number_of_rocks_ordered AS rocks FROM orders;<\/p>\n Now, the column name can later be referred to as simply \u2018rocks\u2019 later.<\/p>\n The results will look like the following:<\/p>\n +—-+——–+<\/p>\n | id | rocks |<\/p>\n +—-+——–+<\/p>\n | 1 | 2 |<\/p>\n | 2 | 3 |<\/p>\n +—-+——-+<\/p>\n This can be especially helpful when providing an API for programmers, as the shorter alias can be returned from the API route to make for a little less typing on the programming side.<\/p>\n How to use ORDER <\/b>BY<\/b><\/p>\n The ORDER BY command can be used to order the results of a query by a particular column. So, using the table from above, you could decide to order the results by the number or rocks ordered, from most to least. To do this, add ORDER BY, followed by the column name or alias, followed by ASC (for ascending) or DESC (for descending), as in the following example:<\/p>\n SELECT<\/p>\n id,<\/p>\n number_of_rocks_ordered<\/p>\n FROM<\/p>\n orders<\/p>\n ORDER BY<\/p>\n number_of_rocks_ordered DESC;<\/p>\n Since you wanted the number of rocks ordered from most to least, DESC was used. This produces the following set of results:<\/p>\n +—-+———————————–+<\/p>\n | id | number_of_rocks_ordered |<\/p>\n +—-+———————————–+<\/p>\n | 2 | 3 |<\/p>\n | 1 | 2 |<\/p>\n +—-+———————————–+<\/p>\n Combining AS and ORDER BY<\/b><\/p>\n Since you can use an alias created by the AS keyword in a later clause, you can combine AS and ORDER BY for this example to provide a result set that is both ordered by most rocks ordered to least, but also has the shorter column name of \u2018rocks\u2019. Here is the query to do this:<\/p>\n SELECT<\/p>\n id,<\/p>\n number_of_rocks_ordered AS rocks<\/p>\n FROM<\/p>\n orders<\/p>\n ORDER BY<\/p>\n rocks DESC;<\/p>\n Notice that the shorter \u2018rocks\u2019 alias is used in the ORDER BY clause, making that a little shorter. The result set from using both AS and ORDER BY looks like this:<\/p>\n +—-+——–+<\/p>\n | id | rocks |<\/p>\n +—-+——–+<\/p>\n | 2 | 3 |<\/p>\n | 1 | 2 |<\/p>\n +—-+——–+<\/p>\n Now the result set is both ordered and uses a shorter name for the number of rocks ordered!<\/p>\n Databases and monitoring with Morpheus<\/b><\/p>\n Morpheus is a SaaS solution which allows you to provision databases, including SQL and NoSQL databases, as well as apps and servers with a user-friendly interface. In addition to this, Morpheus can monitor your apps, servers, and databases. With Morpheus, data logging is automatic as you provision servers and apps. Using the available tools, you can monitor the various parts of your system to keep track of uptime, response time, and to be alerted if an issue does arise.<\/p>\n Source: Morpheus.<\/i><\/p>\n About the author<\/p>\nSQL Database Hacks Using AS and ORDER BY.<\/b>\u00a0<\/b><\/h3>\n
![\"morpheus-interface](\"https:\/\/solutionsreview.com\/cloud-platforms\/files\/2016\/06\/morpheus-interface-1.png\")
<\/p>\n
\n