(SQL Tutorial #8) How to use ORDER BY clause in SQL?
You will learn how to use ORDER BY clause in SQL. ► ORDER BY keyword is used to sort the result-set in ascending or descending order. ► Queries used in this video: 1. Display a table SELECT * FROM hr.employees; 2. Display a table in an ascending order by first_name SELECT * FROM hr.employees ORDER BY first_name; 3. Display employee_id, first_name, last_name ordering in an ascending order by employee_id SELECT employee_id, first_name, last_name FROM hr.employees ORDER BY employee_id ASC; 4. Display first_name, last_name putting in a descending order by salary SELECT first_name, last_name, salary FROM hr.employees ORDER BY salary DESC; 5. Display first_name, last_name order by date SELECT first_name, last_name FROM hr.employees ORDER BY hire_date; ► This video is a part of SQL for Beginners Tutorial series. ► See the PLAYLIST to learn more about SQL commands: https://www.youtube.com/playlist?list=PLArhmGag-BWoPLN8vNw9fPlHPwAVvN-hG 👍👍 👍PLEASE LIKE & SHARE THIS VIDEO with your friends to support us grow! 🔔🔔 🔔DON'T FORGET TO SUBSCRIBE to watch future tutorials https://www.youtube.com/channel/UCMEzw1tTTLLssZSVNPA18aQ TURN ON THE 🔔 BELL ICON TO GET UPDATES FIRST!📩📩📩 ORDER BY clause in SQL | ORDER BY clause in Oracle | #orderByClauseSql #orderByClauseInOracle
Download
0 formatsNo download links available.