SQL ORDER BY, DISTINCT, UNION ALL, LIMIT
https://www.w3schools.com/sql/trysql.... SQL Trainer
This video covers important features for sorting data in a table, collapsing duplicates, merging data from two datasets, and the ability to limit the dataset and page through the data.
Sorting questions are common in interviews.
You need to know how the ORDER BY operator works and what the ASC and DESC parameters do.
How to quickly retrieve unique data in a sample is also useful for passing the interview, specifically how DISTINCT and UNION work.
It's equally important to know how to limit a sample. When there are millions of data points in a table, displaying everything can be detrimental to the database server. Limiting the sample is necessary for every query during testing, and this question will definitely be asked in interviews about how LIMIT and OFFSET work in SQL.
---- Social Media
Telegram, where you can find out about new videos and receive additional content.
https://t.me/webDevGromMaxChannel
P.S. I respond faster on YouTube than on Telegram. I welcome comments on YouTube.
----
To support the channel
1) You can like the video (or dislike it if you didn't like it)
2) Leave a comment longer than 5 words (you can also leave a solved homework assignment)
3) Watch the video to the end (this will increase retention and help me with promotion)
4) Leave feedback in the comments about what could be improved in the video so you don't want to close it.
You can support the channel financially in the following ways:
1) Transfer to a card: https://send.monobank.ua/7oqmsFg3Y
2) Take the survey to help choose the right support options
https://forms.gle/ZbFCKJSpDNYp4AMC6
#sql #grommax
Table of Contents
00:00 - Introduction
00:15 - ORDER BY in SQL
00:46 - Sorting Rows in SQL
02:07 - Sorting by two columns
02:53 - DISTINCT in SQL
03:59 - UNION in SQL
06:10 - UNION ALL in SQL
07:06 - ORDER BY after UNION in SQL
07:43 - LIMIT / OFFSET
09:07 - Homework