Complex SQL Query: Watch Me Write It

[@eminjs2319]

You are constantly producing ONLY top-notch videos. Kudos to you and please, keep this kind of stuff. It is of invaluable importance for us to see the "inner kitchen" of how professionals write complex queries.

[@DatabaseStar]

Thanks for the kind words! I’m glad you and others like this kind of video. It’s the first of this kind that I have made (step by step on writing a complex query) so I’ll keep making more of them.

[@melspiglet]

I love this video and find it incredibly useful. Yes, please, do more videos breaking down the thought process of writing complex queries. Funny, I was like, 'you can't put that in the WHERE clause it goes in a HAVING clause!'... and then that's what you demonstrated & the reason behind it. That boosted my confidence.

[@DatabaseStar]

Thanks, glad you like it! Great to hear you had that thought as you were watching it - I did that deliberately to show what the issue would be.

[@kanugupta1044]

That has been the best video to teach complex SQL in a very light manner!

[@DatabaseStar]

Thanks a lot!

[@katsukido2931]

You need more recognition, your videos are really helpful!

[@DatabaseStar]

Thanks!

[@-.-smile]

Amazing videos, enjoy actually your doing and healing the complex queries. Keep up the great content!

[@DatabaseStar]

Thanks!

[@nirshadnijam2291]

Very concise. Thank you for this video!

[@DatabaseStar]

Glad it was helpful!

[@Franaman]

This is so good and well explained! This is perfect!

[@DatabaseStar]

Glad it was helpful!

[@michellemontemayor4064]

This is very useful! I would love to see more.

[@DatabaseStar]

Thanks! Yeah I have more like this planned.

[@rachaelhanna8523]

Thanks Ben an excellent video. At my work we write a lot of complex queries. I have often wondered if there is a 'best practice' approach to writing them.

[@DatabaseStar]

That’s good to hear you liked it and found it useful.

[@tuilathang97]

Thank you, i am new to SQL and your chanel. You help me a lot sir.

[@DatabaseStar]

No problem, great to hear it’s helping!

[@obadmatar]

Thank you for this well explained video, appreciate your efforts to produce this perfect content.

[@DatabaseStar]

You're welcome! Glad you liked it

[@damishito]

it was a moment when u do a references using pk and fk for the tables? or u just straight do the inner joins ? great vid

[@DatabaseStar]

Thanks! You usually perform joins on the foreign key and primary key, but not always.

[@oracle_professor]

Unique Tutorial

[@DatabaseStar]

Thanks!

[@engr_mark]

You didn't provide the link to the hackrank question as you claimed.

[@DatabaseStar]

Ah good point! Here's the link: www.hackerrank.com/challenges/full-score/problem I'll also add it to the description.

[@ramsay9912]

please, next video about : "Complex PL/SQL Query: Watch Me Write It"

[@DatabaseStar]

That’s a good idea!

[@EUK379]

how to fetch first 3 and last 3 records in oracle sql in single query

[@DatabaseStar]

One way I think you could do it is a query that gets the first 3 rows (using row_number and a where clause) and filter on the top 3 and the bottom 3. Perhaps 2 queries combined with a Union All could be used too.