The ORDER BY and LIMIT Clauses in SQL to Help With Sorting
Details
| Title | The ORDER BY and LIMIT Clauses in SQL to Help With Sorting |
| Author | Becoming a Data Scientist |
| Duration | 3:07 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=wyWnJ7QYME4 |
🎵 Support the artists — buy the original for the best audio quality! 🎵
Description
Learn how to sort your rows by using the ORDER BY clause and how to limit the number of rows shown by using the LIMIT clause.
Queries:
1) Sort your rows in Ascending or Descending Oder: SELECT * FROM table ORDER BY column DESC
2) Limit the number of rows returned: SELECT * FROM table LIMIT 5
Get the Northwind Database: https://www.youtube.com/watch?v=nbIicI7K6Kk
Support the Channel:
1) Subscribe: https://www.becomingads.com/o/youtube
2) DataCamp: https://www.becomingads.com/o/datacamp
3) Udacity: https://www.becomingads.com/o/udacity
