Order result wiht ORDER : Sort Order : Select Clause SQL / MySQL


SQL / MySQL » Select Clause » Sort Order »

 

Order result wiht ORDER



/*

mysql> select * from Student;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
|         1 | John       | Jones     |
|         2 | Gary       | Burton    |
|         3 | Emily      | Scarlett  |
|         4 | Bruce      | Lee       |
|         5 | Anna       | Wolff     |
|         6 | Vic        | Andrews   |
|         7 | Steve      | Alaska    |
+-----------+------------+-----------+
7 rows in set (0.01 sec)

mysql> select * from Student WHERE StudentID != 8 ORDER BY studentID;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
|         1 | John       | Jones     |
|         2 | Gary       | Burton    |
|         3 | Emily      | Scarlett  |
|         4 | Bruce      | Lee       |
|         5 | Anna       | Wolff     |
|         6 | Vic        | Andrews   |
|         7 | Steve      | Alaska    |
+-----------+------------+-----------+
7 rows in set (0.00 sec)


*/
Drop table Student;

CREATE TABLE Student (
   StudentID INT NOT NULL PRIMARY KEY,
   first_name      VARCHAR(50NOT NULL,
   last_name      VARCHAR(50NOT NULL
   
)TYPE = InnoDB;


INSERT INTO Student (StudentID,first_name, last_nameVALUES (4,'Bruce', 'Lee');

INSERT INTO Student (StudentID,first_name, last_nameVALUES (1,'John', 'Jones');
INSERT INTO Student (StudentID,first_name, last_nameVALUES (2,'Gary', 'Burton');
INSERT INTO Student (StudentID,first_name, last_nameVALUES (7,'Steve', 'Alaska');
INSERT INTO Student (StudentID,first_name, last_nameVALUES (5,'Anna', 'Wolff');
INSERT INTO Student (StudentID,first_name, last_nameVALUES (6,'Vic', 'Andrews');
INSERT INTO Student (StudentID,first_name, last_nameVALUES (3,'Emily', 'Scarlett');

select from Student;
  
select from Student WHERE StudentID != ORDER BY studentID;

           
       



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

 Navioo Select Clause
» Sort Order