Tricky SQL Queries for interview

1

SELE! 6eco6e(null+null+1+) from 6ual;

O=T7=T3  Although two C=!! values are not equal, the output is , as decode checks for the eDistence of C=!! and does not compare the two values. 6666666666666666666666666666666666666666666666666666 E. =ind the missing sequence. +able test)number contains the sequence for each id. +able test)number)min)ma2 contains the minimum and ma2imum number for each id. -e need to find the missing number between the minimum and ma2imum number for each id. te2t column can be ignored. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

.E$!E 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.! 0'SE.!

!$DLE test_number(i6 '"#DE.+SE '"#DE.+teTt F$.&$.2(G)) ; 0'!/ test_number F$L"ES(1+1+$$); 0'!/ test_number F$L"ES(1+3+); 0'!/ test_number F$L"ES(1+4+); 0'!/ test_number F$L"ES(1+G+EE); 0'!/ test_number F$L"ES(1++); 0'!/ test_number F$L"ES(1+M+PP); 0'!/ test_number F$L"ES(1+N+&&); 0'!/ test_number F$L"ES(1+1+QQ); 0'!/ test_number F$L"ES(2+1+); 0'!/ test_number F$L"ES(2+2+LL); 0'!/ test_number F$L"ES(2+3+##); 0'!/ test_number F$L"ES(2+4+''); 0'!/ test_number F$L"ES(2++55); 0'!/ test_number F$L"ES(2+M+); 0'!/ test_number F$L"ES(3+1+!!); 0'!/ test_number F$L"ES(3+4+UU); 0'!/ test_number F$L"ES(3+G+VV);

create 0'SE.! 0'SE.! 0'SE.!

tabel test_number_min_maT(i6 number+mn number+mT 0'!/ test_number_min_maT F$L"ES(1+1+12); 0'!/ test_number_min_maT F$L"ES(2+1+J); 0'!/ test_number_min_maT F$L"ES(3+1+G);

18 19 20 21

number);

22 23

 Answer* 1 2 3 4 5 6 7 8

SELE! r i6+rn se ./# (SELE! ./%'"# rn ./# all_obWects %&E.E ./%'"# 13)+ (SELE! ./%'"# r ./# all_obWects %&E.E ./%'"# 4)+test_number_min_maT m %&E.E r>i6 $' rn ,> mn $' rn > mT $' (r+rn) '/! 0' (SELE! i6+se ./# test_number)

OR 1 2 3

SELE! r i6 +l se ./# (SELE! LEFEL l ./# 6ual /''E! DO LEFEL 13)+