SQL Tutorial 2: Order By Clause

Learn about ORDER BY clause in SQL queries. More videos for topics like WHERE, GROUP BY, JOIN, SUB-QUERY, SET OPERATORS etc will be added to this playlist, so please consider subscribing to the channel. This playlist is for tutorial in English. We have created another playlist for tutorials with explanation in Hindi. We are checking if it is feasible to release tutorial playlists with explanation in Marathi and Gujarati. #sqlqueries #sql #sqlforbeginners #sqltraining #mysql #dbms #dbmstutorials #dbmslectures #learnsql #learndatascience #learndatabase #computerscience #datascience #sqlcourse #sqlcommands #sqlquery /*Please review the scripts and use only on test or dummy database*/ /* Create sample table and data*/ /* Test DATA WITHOUT ANY PRIMARY key */ CREATE TABLE mytable1 (mydigit INT, mychar CHAR(1), myvarchar VARCHAR(20), mydate DATE ); INSERT INTO mytable1 VALUES (2, 'M', 'Baban' , '2008-08-30'), (1, 'F', 'Pavni', '2015-09-11'), (3, 'M', 'James', '2011-01-15'); SELECT * FROM mytable1; /* Test DATA WITH mydigit as the PRIMARY key */ CREATE TABLE mytable2 (mydigit INT PRIMARY KEY , mychar CHAR(1), myvarchar VARCHAR(20), mydate DATE ); INSERT INTO mytable2 VALUES (2, 'M', 'Baban' , '2008-08-30'), (1, 'F', 'Pavni', '2015-09-11'), (3, 'M', 'James', '2011-01-15'); SELECT * FROM mytable2; /* Test DATA WITH mydate as PRIMARY key */ CREATE TABLE mytable3 (mydigit INT, mychar CHAR(1), myvarchar VARCHAR(20), mydate DATE PRIMARY KEY ); INSERT INTO mytable3 VALUES (2, 'M', 'Baban' , '2008-08-30'), (1, 'F', 'Pavni', '2015-09-11'), (3, 'M', 'James', '2011-01-15'); SELECT * FROM mytable3; /* Try these SELECT statements on the sample data */ SELECT * FROM mytable1; SELECT * FROM mytable1 ORDER BY mydigit; SELECT * FROM mytable1 ORDER BY 1 ; SELECT * FROM mytable1 ORDER BY mydigit ASC ; SELECT * FROM mytable1 ORDER BY 1 DESC ; SELECT * FROM mytable1 WHERE mydigit != 3; SELECT * FROM mytable1 WHERE mydigit != 3 ORDER BY mydigit; SELECT * FROM mytable1 ORDER BY mychar , mydigit DESC ; SELECT * FROM mytable1 ORDER BY 2 , 1 DESC ; SELECT *, SUBSTR(myvarchar,3,1) AS not_in_table FROM mytable1 ORDER BY not_in_table ; SELECT *, SUBSTR(myvarchar,3,1) AS not_in_table FROM mytable1 ORDER BY 5 DESC ; SELECT myvarchar FROM mytable1 ORDER BY mychar ; VALUES (CURRENT_DATE), (DATE_ADD(CURRENT_DATE,INTERVAL 1 DAY )), (DATE_ADD(CURRENT_DATE, interval 15 DAY )); VALUES (CURRENT_DATE), (DATE_ADD(CURRENT_DATE,INTERVAL 1 DAY )), (DATE_ADD(CURRENT_DATE, interval 15 DAY )) ORDER BY 1 DESC ;

Видео SQL Tutorial 2: Order By Clause автора MySQL Техники