TCS SQL Interview Questions | SQL Server | SQL Interview Preparation | Part 43

TCS interview questions and answers: Find Us On YouTube- "Subscribe Channel to watch Database related videos" https://www.youtube.com/channel/UCZA_5vGtSpZu86VBDdSnSag For SQL Quiz- https://www.youtube.com/watch?v=IaDXFyZSo7Y&list=PLNRxk1s77zfitFbrlRICVDgVodMr25mYl Find Us On FaceBook- https://www.facebook.com/SS-Unitech-187705388674384/ ---Query Question : 1-- CREATE TABLE COLVALUES ( COL1 VARCHAR(5), COL2 VARCHAR(5), COL3 VARCHAR(5), ) INSERT INTO COLVALUES VALUES ('A','B','C'),('X','Y','Z'),('1','2','3'),('100','200','300'),('P','Q','R') SELECT COL1,COL2 FROM COLVALUES UNION ALL SELECT COL1,COL3 FROM COLVALUES ORDER BY COL1 -----Query---Question : 2-- CREATE TABLE DISTINCTVALUES ( COL1 int, ) INSERT INTO DISTINCTVALUES VALUES (1),(1),(1),(2),(2),(3),(4),(4) SELECT * FROM DISTINCTVALUES UNION SELECT * FROM DISTINCTVALUES