Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?

Related MCQs

• …………….. is used to determine whether of a table contains duplicate rows.
• To eliminate duplicate rows ……………… is used
• Which SQL function is used to count the number of rows in a SQL query?
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• A           is a query that retrieves rows from more than one table or view: