DISTINCT keyword eliminates duplicate records
Answers
Answered by
51
Answer:
ᴛʜᴇ ᴅɪsᴛɪɴᴄᴛ ᴋᴇʏᴡᴏʀᴅ ᴇʟɪᴍɪɴᴀᴛᴇs ᴅᴜᴘʟɪᴄᴀᴛᴇ ʀᴏᴡs ғʀᴏᴍ ᴀ ʀᴇsᴜʟᴛ. ɴᴏᴛᴇ ᴛʜᴀᴛ ᴛʜᴇ ᴄᴏʟᴜᴍɴs ᴏғ ᴀ ᴅɪsᴛɪɴᴄᴛ ʀᴇsᴜʟᴛ ғᴏʀᴍ ᴀ ᴄᴀɴᴅɪᴅᴀᴛᴇ ᴋᴇʏ (ᴜɴʟᴇss ᴛʜᴇʏ ᴄᴏɴᴛᴀɪɴ ɴᴜʟʟs).
Answered by
0
Answer:
ᴛʜᴇ ᴅɪsᴛɪɴᴄᴛ ᴋᴇʏᴡᴏʀᴅ ᴇʟɪᴍɪɴᴀᴛᴇs ᴅᴜᴘʟɪᴄᴀᴛᴇ ʀᴏᴡs ғʀᴏᴍ ᴀ ʀᴇsᴜʟᴛ. ɴᴏᴛᴇ ᴛʜᴀᴛ ᴛʜᴇ ᴄᴏʟᴜᴍɴs ᴏғ ᴀ ᴅɪsᴛɪɴᴄᴛ ʀᴇsᴜʟᴛ ғᴏʀᴍ ᴀ ᴄᴀɴᴅɪᴅᴀᴛᴇ ᴋᴇʏ (ᴜɴʟᴇss ᴛʜᴇʏ ᴄᴏɴᴛᴀɪɴ ɴᴜʟʟs).
Similar questions