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:
  • НаукаНаука

Комментарии • 16

  • @Gadalac
    @Gadalac 2 года назад +5

    This was a perfect tutorial! Exactly what I needed, thank you!!

  • @reganpond4870
    @reganpond4870 4 года назад

    these videos are incredible. THANK YOU

  • @nikhils2839
    @nikhils2839 3 года назад +2

    Great vids !!Keep up the great work !!

  • @MrWardo2009
    @MrWardo2009 Год назад

    Thank you for doing these videos!

  • @juliakristavilladiego4425
    @juliakristavilladiego4425 3 года назад +1

    Thank you. Really helpful!

  • @zeusignap1477
    @zeusignap1477 4 месяца назад

    Thanks for sharing your knowledge.

  • @user-ir9ov3dp7r
    @user-ir9ov3dp7r Год назад

    thank you, regards from brasil

  • @Irades
    @Irades 2 года назад

    Thank you ❤️

  • @ahmedrizvi4080
    @ahmedrizvi4080 4 года назад +2

    Hey man, I'm really enjoying your content. Keep up the good work!

  • @WhistlewithRishi
    @WhistlewithRishi Год назад

    Great video

  • @badooral-holibi2281
    @badooral-holibi2281 Год назад

    one the point 🤩

  • @dorayoung5149
    @dorayoung5149 5 месяцев назад

    Nice

  • @bradj229
    @bradj229 Год назад

    LIMIT is the TOP function in TSQL I believe.

  • @zeusignap1477
    @zeusignap1477 4 месяца назад

    Comment for algorithm!

  • @jkayode69
    @jkayode69 Год назад

    Should you wanted to know the least ordering countries instead of the best 5 countries with LIMIT clause