Рет қаралды 272
#setoperations #sqlsetoperators #setoperators #union #unionall #minus
#sqlpatternmatching#sqllikeoperator
#likeinsql#sqllike#setoperators#setoperatorsinsql
#setoperatorsinsnowflake#setoperatorsinsnowflakesql
#unionunionallintersectminus#sqlinterviewquestions
#sqlinterviewquestionsandanswers
#sqlinterviewquestionsandanswersforfreshers
#sqlinterviewquestionsandanswersforexperienced
#sqlquerynameshouldStartwithRandtotallengthshouldbe5
#NameshouldStartwithRandtotallength4
#NameshouldStartwithRandshouldendwithu
CREATE TABLE EMP_DTLS_T(ID NUMBER,
NAME VARCHAR2(20));
INSERT INTO EMP_DTLS_T VALUES(1,'PRAVEEN');
INSERT INTO EMP_DTLS_T VALUES(2,'KUMAR');
INSERT INTO EMP_DTLS_T VALUES(3,'Praveen');
INSERT INTO EMP_DTLS_T VALUES(4,'Ram');
INSERT INTO EMP_DTLS_T VALUES(5,'praveen');
INSERT INTO EMP_DTLS_T VALUES(6,' praveen ');
INSERT INTO EMP_DTLS_T VALUES(7,' pra vee n ');
INSERT INTO EMP_DTLS_T VALUES(8,'kumar Praveen');