Bissoy.com
Doctors Medicines MCQs Q&A

The keyword used with UNION that retains duplicate rows is ______________

The keyword used with UNION that retains duplicate rows is ______________ Correct Answer ALL

The keyword ‘ALL’ used along with ‘UNION’ is not synonymous with just the ‘UNION’ statement. It produces the duplicate rows, if they exist, from the combination of the two tables in the SELECT query.

Related Questions

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 . . . . . . . .
Which keyword used with UNION does not retain duplicate rows?
The keyword used with UNION that does not retain duplicate rows is _____________
The keyword used with UNION that does not retain 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.
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 ?
Which Keyword is used to remove duplicate rows in the result set?