The ORDER BY and LIMIT Clauses in SQL to Help With Sorting
HTML-код
- Опубликовано: 4 янв 2020
- 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: • How to Load a Sample P...
Support the Channel:
1) Subscribe: www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity: Наука
This was a perfect tutorial! Exactly what I needed, thank you!!
these videos are incredible. THANK YOU
Great vids !!Keep up the great work !!
Thank you for doing these videos!
Thank you. Really helpful!
Thanks for sharing your knowledge.
thank you, regards from brasil
Thank you ❤️
Hey man, I'm really enjoying your content. Keep up the good work!
Great video
one the point 🤩
Nice
LIMIT is the TOP function in TSQL I believe.
Comment for algorithm!
Should you wanted to know the least ordering countries instead of the best 5 countries with LIMIT clause