PwC SQL Interview Question - STRING_SPLIT(), CROSS APPLY & CROSS JOIN

SQL questions recently asked in PwC interview. To find out the expected output, I use STRING_SPLIT(), CROSS APPLY & CROSS JOIN --Create table syntax CREATE TABLE testtbl (cola VARCHAR(10)) -- Insert data into the table INSERT INTO testtbl (cola) VALUES ('1,2'), ('3'), ('4') For more SQL interview questions. Check out our playlist. https://youtube.com/playlist?list=PLxHEfsUVhEwMqw-nDG2zd3mpXpvY1v9xX&si=wT1GK4FFWAsLRxpX Contact us: [email protected] Follow us on Instagram : instagram.com/cloudchallengers Facebook : facebook.com/cloudchallengers LinkedIn : linkedin.com/company/cloudchallengers