How Many Of These SQL Tricks Do You Actually Know ?
HTML-код
- Опубликовано: 10 фев 2025
- Learn These Amazing SQL Tricks to Take Your SQL Skills To The Next Level!
And Don't Forget to Tell Us Your Favorite Trick in the Comments for a chance to win Exciting Prizes sponsored by LearnSQL.com #sponsored
Practice SQL Queries on Your Browser through Interactive Courses -
learnsql.com/?...
You can Find The Contest Rules here -
• Post
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate
imp.i384100.ne...
Practice SQL Queries on Your Browser through Interactive Courses -
learnsql.com/?...
Recommended Laptops
Lenovo IdeaPad Slim3 Gen8
lenovo-in.zlvv...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Blog - know-star.blogs...
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org
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 -
ruclips.net/user/postUgkxW1ZFWVGi8yo-7GhDsMJ44SbGR0_GHWk4?si=SRIw9QZIO6jmfkzF
Thank You All For Participating In This Contest. The Contest is Now Over and Winners have been declared here -ruclips.net/user/postUgkx29_FwKt471SwP3sbVhb7kK_YsUs1sFFi?si=7rTiXw-B0m3qjzrH
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 trick is using convert to format dates it really makes it easy to work with it.
My favorite is OUTPUT feature ❤.
I loved the "IIF()" Trick to apply the conditional check of 1 or 0, this trick video for SQL is very helpful i learned a lot in the video, thanks a lot for making this video 🙏
The one with IIF is really cool. My favourite.
I liked IIF trick a lot as it simplifies things.
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!
Output is really helpful, my favourite
My Favorite SQL Trick is LAST AFFECTED ROWS using OUTPUT clause.
IIF trick I find is very useful. Thanks for such informative content.
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.
Columns concatenation sounds great for me
My Favorite Trick is Generate date range using table value constructor
Output features 🎉
All tips and tricks are nice, but I like the COALESCE FUNCTION thank you for sharing.
Generate Date Range my personal favourite
Thank you for your constructive content. I like the output function more
My favorite sql trick is the COALESCE function.
Insert values with output function is really awesome
@prasadraja17 - Congratulations on winning the 2nd Prize. Please send an email to learn@knowstar.org sharing your email address to get the prize.
@@LearnatKnowstar Abhi unsubscribe karna padega channel kya dekake winners banaye pata nahi
I love all the tricks bcoz it makes me best by using them. Tq for giving us with the updates😊❤
I wouldn't say these are tricks, but rather useful techniques. Some of them, like GENERATE_SERIES, were introduced only in SQL Server 2022. Some, like formatting, don't make sense in SQL queries because they need to be done on the client side.
But overall, they're informative and useful. Thanks!
For me TRIM function to remove unwanted characters from string is really helpful.
@crickmoments3732 - Congratulations on winning the 1st Prize. Please send an email to learn@knowstar.org sharing your email address to get the prize.
@LearnatKnowstar Sent mail please check. And thank you so much for creating wonderful videos.
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.
ruclips.net/video/R7TllIFkq94/видео.html
@@LearnatKnowstar yeah string_agg is also another way. Thanks for sharing