Bissoy.com
Doctors Medicines MCQs Q&A

The keyword used with UNION that does not retain duplicate rows is _____________

The keyword used with UNION that does not retain duplicate rows is _____________ Correct Answer DISTINCT

The keyword ‘DISTINCT’ used along with ‘UNION’ is synonymous with just the ‘UNION’ statement. It produces only the distinct rows from the combination of the two tables in the SELECT query.

Related Questions

Which keyword used with UNION does not retain duplicate rows?
The keyword used with UNION that does not retain duplicate rows is . . . . . . . .
Which keyword used with UNION retains duplicate rows?
The keyword used with UNION that retains duplicate rows is ______________
The keyword used with UNION that retains duplicate rows is ___________
The keyword used with UNION that retains duplicate rows is . . . . . . . .
Match List - I with List - II : List - I List - II A. Stamp duties and duties on medical I. Duties levied by the Union Government but collected and appropriated by the State B. Duties on succession to property other than agricultural land II. Taxes levied and collected by the Union but assigned to the States C. Taxes on income other than corporation tax and taxes on agricultural income III. Taxes levied and collected by the Union and distributed between the Union and the States D. Excise duty on items other than medical and toilet preparation IV. Taxes levied and collected by the Union but which may be distributed between the Union and the States Choose the correct answer from the options given below :
Consider the following for the dissolution of trade unions under the Trade Union Act, 1926. Which of the following statement(s) is/are correct?
1. When a registered Trade Union is dissolved, notice of the dissolution is signed by nine members and by the Secretary of the Trade Union.
2. The notice of dissolution must be sent within ten days to the Registrar.
3. Where the dissolution of a registered Trade Union has been registered and the rules of the Trade Union donot provide forthe distribution of funds of the Trade Union on dissolution, the registrar shall divide the funds amongst the members in such manner as may be prescribed.
Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table
When all the students in a school are made to stand in rows of 54, 30 such rows are formed. If the students are made to stand in rows of 45, how many such rows will be formed ?