(SQL Tutorial #9) Learn to use ROWNUM in | SQL | Oracle |

Описание: You will learn how to use ROWNUM in SQL in this video.
► ROWNUM clause is used to specify the number of records to return.
► Queries used in this video:
1. Display a table
SELECT * FROM hr.employees;
2. Display the first 7 rows only.
SELECT * FROM hr.employees WHERE ROWNUM ▶️7;
3. Display the first 5 rows only and sort by employee_id
SELECT * FROM hr.employees WHERE ROWNUM▶️5 ORDER BY employee_id;
4. Display the first 10 rows only and only the records with department_id = 90 sorted in an ascending order.
5. SELECT * FROM hr.employees WHERE ROWNUM▶️10 AND department_id=90 ORDER BY employee_id ASC;
6. To compare results of OR and AND operators:
SELECT * FROM hr.employees WHERE ROWNUM▶️10 OR department_id=90;
** ▶️ means less than**

►This video is a part of SQL for Beginners Tutorial series.
► See the PLAYLIST to learn more about SQL commands:    • SQL Quick Tutorials for Beginners [Best St...  

👍👍 👍PLEASE LIKE & SHARE THIS VIDEO with your friends to support us grow!
🔔🔔 🔔DON'T FORGET TO SUBSCRIBE to watch future tutorials    / @apieceofcodelabs  
TURN ON THE 🔔 BELL ICON TO GET UPDATES FIRST!📩📩📩



#rownumInSql #rownumInOracle