| |
MySQL Tutorial - Order By
We can use ORDER BY statement to make MySQL results easier to read and understand. A common way to do this in the real world is to order a big list of items by name or amount. The way to order your result in MySQL is to use the ORDER BY statement.
What ORDER BY does is it takes the a column name that you specify and sorts it in alphabetic order (or numeric order if you are using numbers).
Query: Show all records not containing the name "Paul" AND the Alarms on Node 'SCADA3' order by the Time.
SELECT * FROM [table name] WHERE name != "Paul" AND NodeName= 'SCADA3' ORDER BY TimeIn;
Go Back To MySQL Tutorial
|
|
|
|
|
