SQL Server Queries Part 2 - ORDER BY (Sorting in Queries)

[@subhashkomy]

You Are really great. I am working with SQL Server for many years. Each of your videos give something new technicians. Your channel is my one of the best KZbin channel so far. Very simple way you explain, very easy example to understand . You are doing really good job sir. God Bless you.

[@michaelberg6502]

Hey Andrew, I just wanted to express my gratitude for your great tutorials and thank you for the obvious effort you put in to build them! Keep on helping people by passing on your knowledge

[@adrianinnavan3910]

Nice tutorial. I thought I would know the first two tutorials but each one has taught me something. To reciprocate, I would point out that if you wish to be lazy with your sorts you can use the column numbers. Use ORDER BY 3, 1 to sort by column 3 and then by column 1.

[@kerryevert7127]

Thank you so much for these videos. I've just started a new job and this is a huge area of what I will be doing - in a very basic way - and trying to read books about writing queries has just about bored me to death! This has taught me LOADS!

[@nstar0203]

On the contrary, your voice is so soothing!

[@CodeXploit]

Your channel has great videos. Nice explanation, nice pace. And im quite happy that someone makes these videos that does not have a heavy Indian accent.

[@unity-gain]

You can also use the field number to sort by. For example instead of FilmName or Title you could use ORDER BY 1. Although this makes things a bit less ‘readable’ if that’s a concern. Great video series. I’ve been writing T-SQL for years and still go through them and learn things.

[@jonathancrankshaw589]

Thank you for the videos! Helping me get caught up after 5+ years out of the SQL game

[@amgdhussein7040]

Best SQL videos on the Internet

[@femi2873]

I totally agree with you

[@muhammedcansoy1434]

Excellent

[@WiseOwlTutorials]

Thank you!

[@study9246]

Thank you for sharing your knowledge. REally appreciate common errors and useful sorting options.

[@alkuwaikbi]

Wonderful tutorials. I must say the best so far

[@alkuwaikbi]

I am watching them all. I am preparing for MSCA exams :) Cheers.

[@AnnaDeNinno]

Agreed. Thorough, precise, logical, good tone volume and rhythm, clear sound, excellent examples, informative, and I could go on. Videos appreciated.

[@dishantpatel6610]

Awesome tutorials!! Helped me a lot

[@WiseOwlTutorials]

Happy to hear that Dishant, thanks for watching!

[@chahineatallah2636]

Great Videos as usual, i learned vba from ur courses, now sql, next will be python

[@WiseOwlTutorials]

Happy to hear it! Hope you enjoy the Python course!

[@twilightdream7190]

you know what, you save my life

[@WiseOwlTutorials]

Happy to help!

[@twilightdream7190]

@@WiseOwlTutorials many thanks!

[@WiseOwlTutorials]

@@twilightdream7190 You're very welcome!

[@Sameer76567]

Thanks so much sir! I learnt entire MSBI by looking at your videos. I was wondering if you can also post videos on data analytics and data visualization ( Tableau).

[@charlyclerfeuille4212]

NB : Ties does not work if you have 2 successive orders Thanks for this very good video.

[@WiseOwlTutorials]

You're welcome! I disagree though about WITH TIES - if you order by more than one column, the values in all ordered columns must be the same to be considered a tie. I hope that helps!

[@kungfusaini]

Fantastic video, helped me out loads. Great job!

[@bogdanudovicic391]

Very nice, as always. Thank you.

[@punchline1729]

No complaint is fair to these SQL series, I keep reviewing them once in a while so that It sticks to my brain, needless to say, I'm learning SQL for game programming using Unreal engine particularly in order to run a basic multiplayer server using Microsoft SQL server DBMS

[@WiseOwlTutorials]

Nice! That's definitely the best use case I've heard for the advice in any of these videos :D Good luck with your game!

[@justinbanza4751]

Thank you very much for this video

[@WiseOwlTutorials]

You're welcome Justin, thanks for watching!

[@markobozovic7853]

Great tutorials!

[@krismaly]

Enjoyed this video. Thanks a bunch.

[@khalidz1981]

After the ORDER BY clause you can also add the number of the field in the select list, like this SELECT FilmName,FilmReleasDate,FilmRunTimeMunites FROM tblFilms ORDER BY 1 -----> order by FilmName ORDER BY 2 -----> order by FilmReleasDate ORDER BY 3 -----> order by FilmRunTimeMunites

[@ipsitapani8641]

yes nice explanation sir.thank u.

[@forzaalgiers2045]

Thank you, for the great Job you're doing for us, my Qs : Any advice for people who are new to SQL (any of your videos to watch?), if not just give us a starting point(video) and thank you again

[@forzaalgiers2045]

Thanks , I will follow your advice for sure, as a beginner , I will go for SQL Server 2016, is that OK ?

[@forzaalgiers2045]

Great, I will go for it, Thanks

[@tejasvi0claw]

Thank you, sir :) Your voice has a strange resemblance to that of Christoph Waltz's.

[@monicachopra8926]

thank you, it is very helpful.

[@silentoperator1]

Nice series! Thanks. Question. Can you add the ORDER BY statement above the FROM statement and get the same results? Thanks

[@danford2490]

Hi Andrew we have not heard from you for sometime now. We hope you are well ..

[@thaiiexpat10]

Question - I have used MS Access and I know it well. So I understand basic databasing. I need to change to get a database that can run a company, on the Cloud. I was told to try SQL. Does SQL have a front end that is very intuitive / easy like MS Access? I understand what you are doing here, and I acutally love it, but, can I build a database in a more Intuitive format? Not by typing code but by inputting fields etc.. like MS Access?

[@gtmashok]

This may have been asked below. But what if I wanted to fetch the Bottom 10 records of a table? Sometimes I may not want to alter the 'ORDER BY' command lines.

[@monik_v]

thank you very much for your tutorial very straightforward. I have a question a have series of different tables and I want to be able to get the address from one of the tables by just typing the folio number which i have in another table. Is this possible, I think I have to create a Join table for this am I wrong. Thank you in advance for your help

[@rugwizainnocent1881]

Excellent. Is there anywhere I can download the Movies Table for practice? thank you

[@tamershahin5658]

100000000000000000000000000000000000000 like great work,,thanks

[@darthplaguepiss4335]

thanks mane

[@je2nd460]

@wiseowltutorials where can I download the movies database on this tutorial? thanks!

[@sensi0007]

hi im using your videos for learning sql server 2012 but i dont have the database info that you are using where do i get it from please many thanks andy

[@Cottosweet]

I was just about to shoot myself in the head until I found this tutorial video... thanks!

[@mfaani]

***** lol

[@laxmisidhu4483]

Great

[@iticcl3565]

I need to connect SQL server2000 to Visual studio 2015. but how help me to do this work

[@weishenliu2826]

Hi, I tried using "WITH TIES", but I don't get the additional few which tied at the 10th place. I checked that 11th and 12th place has the same number of oscarwins as 10th. May I ask if there's anything I did wrong?

[@weishenliu2826]

Ok, sorry, I found my mistake. I kept the sort field of duration and filmname. That's why 11th and 12th place are not considered tied with 10th place.

[@szymonbaranowski8184]

wasn't Null considered highest value not lowest?

[@WiseOwlTutorials]

Hi! No, NULL is treated as the lowest possible value learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver16 I hope it helps!

[@yucelozyazgan]

Problem: I just added TITLE justafter [OSCAR WINS] to put it in alphabetic order But it didn't worked with alphabetic order demanding. The list was not in alphabetic order and the number of it was not 13 SELECT TOP 10 WITH TIES F.FilmName AS TITLE, F.FilmOscarWins AS [OSCAR WINS] FROM DBO.tblFilm F WHERE FilmOscarWins IS NOT NULL ORDER BY [OSCAR WINS] DESC, TITLE The result : TITLE OSCAR WINS 1.The Lord of the Rings: Return of the King 11 2.Titanic 11 3.Gandhi 8 4.Dances With Wolves 7 5.Schindler's List 7 6.Star Wars: Episode IV - A New Hope 6 7.Terminator 2: Judgement Day 6 8.American Beauty 5 9.Around the World in 80 Days 5 10.Braveheart 5 what's the mistake ?

[@MurtazaNaqvi-t2b]

I CANNOT HEAR HIM

[@ib3788]

This suck

[@femi2873]

Best SQL videos on the Internet

[@WiseOwlTutorials]

Thank you so much Ade! Happy to hear that you like the videos and thank you for taking the time to leave a comment!