Automation Media

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;

MySQL
MADE EASY ....

MySQL - Basics

MySQL - Basic

MySQL - Pronounced AS

MySQL - Introduction

MySQL - Setup

MySQL - Cost

MySQL - Admin

MySQL - Syntax

MySQL - Database

MySQL - Connect

MySQL - Create Database

MySQL - Create Tables

MySQL - Insert

MySQL - Query

MySQL - Fetch Array

MySQL - Select

MySQL - Where

MySQL - Order By

MySQL - Join

MySQL - Left Join

MySQL - Update

MySQL - Delete

MySQL - Backup

MySQL - Aggregate Functions

MySQL - Count

MySQL - SUM

MySQL - Avg

MySQL - Max

MySQL - Min

MySQL - Group By

MySQL - Advanced Topics

MySQL - SQL Injection

MySQL - Date

MySQL - Time

MySQL - Index

MySQL Tutorial - Order By MySQL for Engineers / Technologists

MySQLMADE EASY ....

MySQL Tutorial - Order By
MySQL for Engineers / Technologists

MySQL
MADE EASY ....