Can you show unpivot

Thank you

Excellent 👍 👌

Primary key can be multiple columns. Look up "composite primary key"

Then if we want to use in group by or where how to use it?

Thanks for reminding me of RANK... I always forget about that one.

❤ love this explanation.

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Practice SQL Queries on Your Browser through Interactive Courses - learnsql.com/?ref=otm1ytl

Ek point ko smjhane k liye 50 line aap English bolti h aise kaise chalega madam try to speak in Hindi😅

Concept dekhe ya english smjhe tumhari😂

Superb 👍

Good information 👍

In case anyone is looking for more suggestions on this: WITH RowNum AS (IdentifierColumn1, IdentifierColumn2, DateFrom, DateTo, row_number() over(partition by IdentifierColumn1 order by DateFrom) as rn FROM Table), RowNum1 AS (Select * From RowNum), RowNum2 AS (Select * From RowNum) SELECT R1.IdentifierColumn1, R1.IdentifierColumn2, R1.DateFrom, R2.DateFrom, R1.DateTo, R2.DateTo FROM RowNum1 R1 LEFT JOIN RowNum2 R2 ON R1.IdentifierColumn1 = R2.IdentifierColumn1 AND R1.IdentifierColumn2 = R2.IdentifierColumn2 AND R1.rn = R2.rn+1 WHERE (R2.DateFrom > R1.DateFrom AND R2.DateFrom < R1.DateTo) OR (R2.DateTo > R1.DateFrom AND R2.DateTo < R1.DateTo) ORDER BY R1.IdentifierColumn1, R1.IdentifierColumn2, R1.DateFrom, R1.DateTo

Excellent 👌👌👌

Brilliant

This is great thanks. Is it possible to calculate the rolling Mode? So looking at the rolling mode over the past 7 days?

Will this work for bold,italic character

very good tutorial. I have 4 image columns, how do I signify which column to insert the image into?

I think another alternative is Sp_whoisactive

How to get distinct record ls in string aggregate function

Thank you

Thank you for a lucid explanation!

Great explanation.

How we can install Datastage at local system ?

Thanks for the info Helpful

thanks. given that it requires two characters, why does it not filter out the nulls?

Nice

Whats the best way to do this in general, in other databases

Great to hear

Hi in place of maxsal=1 I want max salary value for all records is it possible let me know

I like your SQl Videos very much, Can you please cover a scenario of the sending email part where most of the companies have corporate service account outlook mails, so how to send email here , what are things needed , I don't think a simple SMTP can send emails because of several security policies and mainly Mails are protected with MFA.

Good method

1234567

Where is the link to create that specific password?Cant find in the description

great 👍👍👍