Video

You should explain the question first.

Thank you for your efforts to explain these complex quarries, I understood the explanation but did not understand why why used row_number =1 , I would appreciate your clarification from the same.

Full video dalo na adha hi hai ye Bhai

SSIS pr v playlist start kro sir ❤🎉

Grt job..1 advice...It would be better if u also provide the data scripts so we can also practice the questions in our machine

Could please provide the dataset for this video 😊

Well explained brother

with cte as( select *, min(order_date) firstOrder from Delivery group by customer_id ) select round(sum(firstOrder = customer_pref_delivery_date) * 100 / count(*), 2) immediate_percentage from cte; why is this not working?

101, 450

sir please upload daily video of python, its very helpful and in hindi we clearly understand each line, please upload daily

First like

Getting error “ the query processor could not produce a query plan because the target DML table is not hash partitioned” Able to read duplicates but only delete is not working

👍👍👍👍👍

❤😮tq sir

I am fresher preparing for data analystics domain, for queries will it be enough for me to solve the question you tell in your playlist as fresher or extra is there any need to do.

Thank you sir for making this type of video,, its help me a lot☺

🙏🙏❤

The best channel for SQL i would say you are doing a great work brother Keep it Up!

❤

Is null

Recursive procedure bhi batao na explain pls

split full name in 3 column using store procedure please create video on this question eg. full name - ABC PQR XYZ OP: FIRST NAME ! Middle Name ! Last name ABC ! PQR ! XYZ

Great video, sir. I'm new to cloud data engineering and I want to learn advanced SQL. Could you please help me?

SQL> select e.*,concat(concat(trunc((age-1)/10)*10+1,'-'),trunc(((age-1)/10)+1)*10) as employee_age from employee_age e; EMP_ID AGE EMPLOYEE_AGE ---------- ---------- --------------------------------------------------------------------------------- 1 5 1-10 2 16 11-20 3 19 11-20 4 31 31-40 5 50 41-50

Union

Complete nahi ho raha hai ek bhi query

A

A

Bhai query kaha hai

A

Bhai pura query nahi hoa video khatam hogaya us se pahle hi.

।

This helps me a lot thank u so much sir ♥

Please provide course notes

A,c

not able to see complete out put, if you minimize your image then it is possible to see. Request you to please minimize your image. Thank you!

row_number() built-in function hai? and row_number() ke sath over() q use kiya hai aapne?

bro cte to table name hai na yha pr cte ke place par aur dusra koi sa v name bhi likh sakte hai na and row_number() built-in function hai? and row_number() ke sath over() q use kiya hai aapne?

a

Nice videos ....Please continue posting leetcode videos.

Upload answer also, I hope you know yourself. Otherwise it's just useless.

Imma revise SQL and reply with the code, last wrote 3 months ago

But this solution has a flaw... Like if 20,21 20,21 present two time ... I mean duplicate row then also thos query will consider it as a symmetrical pair...

Best approach 🔥🔥🔥

mahaan ho bhai mahaan...

Bhai koi other way bhi hai ky aisey solv krne ka

Keep up the good work 😊

didn't understand the COUNT() part...if any pair having count = 1 then it can also be a pair ??

bhai yaar aapne jo logic lagaya usme mano id 6 repeat hoga 3 tym to usme row_num 1,2,3 aayega .. to usme toh id - row_num =0 nahi hoga ..

bhut ache se samjhaye bhaiya ji