In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?
A) DELETE
B) DISTINCT
C) NOT EXISTS
D) UNIQUE
E) KEY
Correct Answer:
Verified
Q43: A WHERE clause can contain another SELECT
Q53: Only two tables can be queried by
Q54: Two or more tables are joined by
Q56: The clause SELECT COUNT (*)results in a
Q62: In an SQL query,which of the following
Q63: Given a table with the structure: EMPLOYEE
Q64: In an SQL query,which built-in function is
Q65: In an SQL query,which SQL keyword is
Q66: In an SQL query,which of the following
Q73: Joins that show the matching rows from
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents