Don't Forget to Tell Us Your Favorite Trick in the Comments for a chance to win Exciting Prizes sponsored by LearnSQL.com #sponsored Please NAME the SQL Trick in a proper sentence and not just the Trick Number. Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl You can Find The Contest Rules here - ua-cam.com/users/postUgkxW1ZFWVGi8yo-7GhDsMJ44SbGR0_GHWk4?si=SRIw9QZIO6jmfkzF
I hvae always liked the little tricks we can do with Coalesce function. Loved this video but the one with the COALESCE function is my favorite and the one I use the most.
All the tricks are great! Personally, I really liked the value table, value constructor, and date format examples. Thanks for uploading such an amazing video. I never regret being your subscriber because I’ve learned so much SQL-related knowledge from your channel.
Don't Forget to Tell Us Your Favorite Trick in the Comments for a chance to win Exciting Prizes sponsored by LearnSQL.com #sponsored
Please NAME the SQL Trick in a proper sentence and not just the Trick Number.
Practice SQL Queries on Your Browser through Interactive Courses -
learnsql.com/?ref=otm1ytl
You can Find The Contest Rules here -
ua-cam.com/users/postUgkxW1ZFWVGi8yo-7GhDsMJ44SbGR0_GHWk4?si=SRIw9QZIO6jmfkzF
Favorites Trick : TRIM - It is really interesting feature glad to learn we can trim specific character.
Absolutely loving Trick No. 2 (IIF Conditional Logic)! It makes dealing with if-else statements a breeze compared to 'Case When'.
I love VALUES. It has so many uses. My favorite.
My favorite is OUTPUT feature ❤.
The one with IIF is really cool. My favourite.
Insert values with output function is really awesome
Output is really helpful, my favourite
My favorite trick is using convert to format dates it really makes it easy to work with it.
Output features 🎉
For me TRIM function to remove unwanted characters from string is really helpful.
I hvae always liked the little tricks we can do with Coalesce function. Loved this video but the one with the COALESCE function is my favorite and the one I use the most.
Trick 4 is my favorite - values table value constructor
Please name the Trick in a proper sentence and not just the Trick Number.
All the tricks are great! Personally, I really liked the value table, value constructor, and date format examples. Thanks for uploading such an amazing video. I never regret being your subscriber because I’ve learned so much SQL-related knowledge from your channel.
Thank You for your support!
I liked IIF trick a lot as it simplifies things.
IIF trick I find is very useful. Thanks for such informative content.
My favorite sql trick is the COALESCE function.
Columns concatenation sounds great for me
All tips and tricks are nice, but I like the COALESCE FUNCTION thank you for sharing.
Generate Date Range my personal favourite
Coalesce is the best for me 👍
GENERATE_SERIESE() FUNCTION AND COALESCE() I LIKED THE MOST
Split_string functions converts string to rows
Is there any best way to do opposite ?? i.e rows to string ??
You can try using stuff for selecting multiple rows as single string item
You can use the STRING_AGG function.
Here is a quick video tutorial on that.
ua-cam.com/video/R7TllIFkq94/v-deo.html
@@LearnatKnowstar yeah string_agg is also another way. Thanks for sharing