วีดีโอ

Thank you bro … very nice explanation 🙏🏼

WRONG OUTPUT , bhai jabardasti ka engrezee bolna band kr de pahle

how we get the data

it also asked to round the line total price by two decimal places. how could the answer be right without that? for eg. the price should be displayed as 950.00 instead of 950

Hi Vivek, thanks for the solution but I have a question over here. Can it be solved using left join? select p.sku, p.product_name from product as p left join invoice_item as i on p.id=i.product_id where i.product_id is null order by p.sku asc

Thanks buddy

Hi , I have a problem , if you have solution please answer. I need to pass date parameter and use a date filter which should be binded to this date parameter. When i am passing from the report view i am getting an error of date format as the date is in format of dd/mm/yyyy and the report view is passing the timestamp as well can we remove the timestamp from the report view filter.

How to enroll and get this certification!?

I solved one of two but still passed😅

13/Jan/24

Please don't put the title in english , and you talk with hindi , use the english to help more people in the world , thanks !

Please provide the code ?????????????

Are the questions same every year?

can we use max()over(),min()over(partition by date type order by date)?

Bhaiya ji Bihar me kaha se hai?

Showing error

U IDIOT DARK THEME KUU KR RAKHI HAI

Kya bat hai Vivek Bhai dill jit liya

For everyone same questions or different questions

Answer is correct but Order by clause bhi use krna tha according to question

hey What if I use ODBC Destination?

What is the use case of dense-rank and rank functions

Please provide the code as a link 🙏

Awesome👍👏😊 Keep it up.

Thanks buddy...great video here

Why when using this method if we use another slicer apart from the calendar other slicers are not working?

You explained really very good. Appreciated! Thank You!

Aapka English hamko bahut aasani se samjh aa jata hai please upload jaldi jaldi video 🙏🙏

Vivek sir aap daily video layiye 🙏🙏

Hi, you don't need so many joins, once you get the quarter(dt) as quarter, next you simply do select algorithm, sum(case when quarter = 1 then volume else NULL end) as transactions_Q1, sum(case when quarter = 2 then volume else NULL end) as transactions_Q2 <similarly for quarter 3 and quarter 4> group by algorithm order by algorithm

where is the code ?

Thanks sir ji 🙏

Sir aap jldi jaldi video upload kigiye sir aapka videos ka hamko intejar rahta hai sir

🔥🔥

Very nice video

thanks for this. youre so good bro,

Winners Chart There were a number of contests where participants each made multiple attempts. The attempt with the highest score is the only one considered. Write a query to list the contestants ranked in the top 3 for each contest. If multiple contestants have the same score in a contest, they are at the same rank. Report event_id, rank 1 name(s), rank 2 name(s), rank 3 name(s). Order the contests by event_id. Names that share a rank should be ordered alphabetically and separated by a comma. Order the report by event_id. Give answer for this please

No curaption in UP.This is a yogi's goverment.please alert nided hear.😄😄

Why hacker rank sql intermediate is protored now ?

Why hackerrank sql intermediate is now proctored ?

75 hai yar bhai

75th hoga bro

❤️❤️❤️❤️❤️ chokha ❤️❤️

😍😍😍

Jai shree kedar

Har Har Mahadev 🙏🚩🚩🚩🚩🚩

Har har Mahadev 🙏🙏🙏🙏

🙏🏻🙏🏻

mele bapu love you 🙏🙏

Har har mahadev