Видео

Hope you find this video helpful. Please hit the like button

Thanks for the comment. Sure, I will make a video.

Thanks! Glad you liked the video.

Thanks

Thanks for your support! Stay tuned for more SQL videos!

sure Saivinith, thanks for the comment. We will make videos on Regex in SQL

Thanks for your comment! We'll be adding an MS SQL course. What specific MS SQL topics would you like to see covered?

Glad you liked it! Thank you for the support.

Yes sure, let me know your contact

Yes, let's discuss. Whatsapp @+91-8142550075

Thank you 🙂

Glad it helped!

yes bro, add chesthunna #1 ala number series..

@@TeluguTechCoder only 4 & 5 numbers matrame vunnai bro 1-3 ekkada?

ok, please check out these links #1 ruclips.net/video/AMZBE4CMAh8/видео.html , #2 ruclips.net/video/FV9Eu0cCmMk/видео.html #3 ruclips.net/video/Uftcd0IFwtA/видео.html

Thanks for the feedback! please like the video and Subscribe to the channel.

Hi bro, full course videos prepare chesthunna, from tomorrow new videos add avuthayi, please Subscribe and like our videos. Thanks for your comment

Glad it was helpful!

Thanks for the comment, inka better ga explain cheyadaniki try chestha...

Thank you!

Thanks a lot

Yes, all three of the examples you provided are valid and can be used in SQL-like queries or when working with datetime data in SQLite or other databases that support the strftime function. Here's a breakdown of each: 1. strftime("%Y", published_datetime) BETWEEN '2018' AND '2020' This will extract the year (as a string) from the published_datetime column and check if it falls between '2018' and '2020'. 2. published_datetime LIKE '%2018%' This query will search the published_datetime for any string that contains '2018'. It is a pattern-matching approach. 3. cast(strftime("%Y", published_datetime) AS INTEGER) < 2016 This will extract the year from published_datetime, cast it as an integer, and check if it's less than 2016.

No, it is MySQL Workbench

Sure, I will

Welcome 😊

In Customers table doesn't have Order_id column so in both table common record was customer _Id that's why she did that What you text that also going to write columns may different but data type should be matched

@@Vabcdefgh oh OK I got it... Thanks for replying and making useful videos

Keep watching

Sure, will work on it.

Thanks

sure...

sure!

Glad to hear that

I will try my best to provide the data set.

To delete duplicate records in a table using SQL, you cannot directly use the DISTINCT keyword because DISTINCT is used to select unique records rather than delete them. However, you can achieve this by using common SQL strategies such as identifying the duplicate records and then deleting them based on their unique identifier, if available.

SQLFiddle: Offers an online SQL editor and execution environment. W3Schools: Offers SQL tutorials and a practice environment.

ok. contact 8142550075

Super 👍 very clear information useful

In SQL, procedures and functions are two distinct types of database objects with different purposes and behaviors. While they both allow you to encapsulate logic and perform actions, they have specific use cases and limitations. The reason you can't directly use a procedure inside a function in most database systems is due to the fundamental differences between these two constructs

@@TeluguTechCoder thank you

Yes, we can, but the approach might vary depending on the database system you're using. Stored procedures are often used for more complex operations, but creating a table is usually a relatively straightforward task. First, I'll cover the basic concepts then I will make video on stored procedure in SQL.