Відео

Here's another way to do it. select * from Country ORDER BY replace(Country_Name, 'India', '0') Since all the other Country Names begin with a letter replacing India with a zero insures it will always be at the top.

How to separate all these characters ? Like abc,123,xyz?kindly make the proper solution of this video

Can you please tell me how to load the data afterwards. Should I do load the update dataset first or insert one first? And what should be the key columns while inserting into the dimension??

Great Explanation !

Thank you!

Nice, i only knew one option. This is a better alternative Thx

I want to calculate last 12 months running sales in sql

In which cases would you need to take this approach?

Is there any another method to do this ?

how do you keep headers on each page?

so change the nulls before unpivot query

Ma'am Please make descriptive vidoes on SQL cursors from basic to advance. it will be helpful.

Your videos are very helpful and i am learning new things. Thanks

Thank you so much its was very help full mam ,after 4 hrs hard work install jupyter notebook with help of your video

It is not working in oracle sql Or developer

Hi Team, Do you have the dataset for all the queries in this playlist. If you can arrange ,it will be very helpful for me

How could you find this useful things? You are a genius and sharing knowledge. Months ago, I got the same issue with this quotations , Thanks for the vid. May I know, you deal with MS SQL?

Tks u

Very Nice. Do you have done this activity in Postgres Database ?

How to get the database for each and every query your sharing

Great and clear explanation on Count(1), * plus ColumnName. Thanks!

Hi ma'am, Can you please provide the data for practice

How to find Customers who placed an Order everymonth in a year. can you make a video?

Thank you. Great efforts.

Finally Found solution after watching many videos thankyou verymuch mam😊

we have column has id a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,a21 the output should be using sql query a1 a2,a3 a4,a5,a6 a7,a8,a9,a10 a11,a12,a13,a14,a15 a16,a17,a18,a19,a20,a21 can u pls explain this scenario

For a limited time, Coursera Plus subscriptions are 75% off now through June 23, 2024, 11:59 PM IST. You can get an annual subscription of Coursera Plus for just INR 7999 (normally INR 33,0001). That’s over 75% in savings for unlimited access to 7,000+ learning programs. Start new courses, move between programs, and learn at your own pace-all for one all-inclusive price. You can check out the offer here (Exclusive for India) - imp.i384100.net/Or7oLK

Superb Trick

This good. Assuming you wanted to get difference between two years e.g 2013 &2014.. How can you achieve that?

Amazing video and very informative

Awesome.

Thanks how can do that on hundreds numbers one time ?

Excellent explanation! Thank you so much 😊

Great tutorial, thank you

FOR THOSE WHO ARE EXCUTING IN mysql set @str1 = 'abc,,def,,,,,ghi,jkl,,,,,mno'; select @str1 as string123; select replace(replace(replace( @str1, ',', '*,'), ',*',''),'*','') as string321;

thanks

a really good video, thanks for the help! 👍

isn't OLEDB for LOCAL connections only, and ODBC if you are connecting to a remote sql server?

Yeah, I found the best example for cross filter direction 👌👌, Without talking too much, the girl jumped to the actual scenario 🤩

Thanks for the wonderful video. Please more Windows functions examples.

Thanks I really need this help with sql server

Your videos are very professional, please make more sql server specific

What's the diff between union and inters3ct

Very very important concept and in easy to understand way of explaining.

0

Dynamic SQL is SQL query that is executed at runtime. I hope the following is not a silly question. But when is it that we need this functionality ? i.e., when do we need some codes to be executed at runtime ?

Nice explanation. Thank you

In my SQL Developer, in that 'DateDiff' and 'DateAdd' functions are not working, you know how to enable those functions?

How to replace leading zeroes with another character