單項(xiàng)選擇題
查看COLORS表中的數(shù)據(jù):RGB__HEX__VALUE------------------FF000000FF000000FFCOLOR__NAME------------------redgreenblue查看BRICKS表中的數(shù)據(jù)BRICK__ID------------------123COLOR__RGB__HEX__VALUE------------------FF000000FF00FFFFFF哪兩條查詢返回COLORS中的所有行()
A.SELECT*FROMbricksbFULLJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
B.SELECT*FROMcolorscLEFTJOINbricksbONb.color_rgb_hex_value=c.rgb_hex_valueWHEREb.brick_id>0
C.SELECT*FROMbricksbRIGHTJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
D.SELECT*FROMbricksbJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
E.SELECT*FROMcolorscLEFTJOINbricksbUSING(rgb_hex_value)
A.SELECT*FROMbricksbFULLJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
B.SELECT*FROMcolorscLEFTJOINbricksbONb.color_rgb_hex_value=c.rgb_hex_valueWHEREb.brick_id>0
C.SELECT*FROMbricksbRIGHTJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
D.SELECT*FROMbricksbJOINcolorscONb.color_rgb_hex_value=c.rgb_hex_value
E.SELECT*FROMcolorscLEFTJOINbricksbUSING(rgb_hex_value)