Bissoy.com
Doctors Medicines MCQs Q&A

Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this? Correct Answer LIMIT

When there is a need to put a limit to the number of rows returned by the ‘UNION’ operation, the statement ‘LIMIT’ is appended to the ‘SELECT’ queries which are joined by the ‘UNION’ operations.

Related Questions

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 :
P, Q, R, Sand T are five crops that Babu grows. T is fast growing and more water demanding than R which gives more yield than T. P gives more yield than R and grows faster than Q. Q is more water demanding than T but is second lowest yielder, S is the slowest growing and least water demanding of all crops but gives highest yield. R is more water demanding and grows faster than P. Select the crop or crops that has/ have as many as crops that are more water demanding and as many as crops that give less yield than it. 
There are eight cars A, B, C, D, E, F, G and H. Each car has a different price. Price of C is more than that of A and D. Price of at least two cars is less than A. Price of F is more than that of G and H. Price of D is less than G, but more than E. Price of B is less than H, but more than G. Price of at least four cars is more than that of C. Which of the following sequence is correct?
Two stock options are available for buying. Each offers a variable rate of return of profit over a period of 10 years. For first 4 years one has an incremental rate of return which increases by 2% per year starting from 3% of the investment and stays constant at 8% for the rest of the period. The second one has a constant annual rate of return throughout and give 10% more return after 10 years. What is the annual rate of return on second option?
Which of the following statements relating to the trade unions under the Trade Unions Act, 1926 are not true?
1. Every registered trade union has to submit a half yearly return to the Registrar of Trade Unions.
2. Any person who has attained the age of eighteen can become an office bearer of the trade union.
3. Retired or retrenched employees of an organisation holding an office in a trade union shall not be construed as an outsider.
4. The number of outsiders working as office bearers in registered trade union functioning other than in an unorganised section shall be limited to eight.
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 ?
The height of a tree is defined as the number of edges on the longest path in the tree. The function shown in the pseudocode below is invoked as height(root) to compute the height of a binary tree rooted at the tree pointer root. int height (treeptr n) { if (n == NULL) return -1;   if (n →  left == NULL)        if (n →  right == NULL) return 0;        else return ; \(\boxed{B1}\);     // Box 1 else { h1 = height (n →  left);          if (n → right == NULL) return (1+h1);          else { h2 = height (n → right);          return ; \(\boxed{B2}\)   // Box 2                        }            } } The appropriate expressions for the two boxes B1 and B2 are
Which of the following are the suggestions to strengthen the Union Movement?
1. Measures should be taken on several forms to strengthen forces building up internal leadership.
2. The minimum number required for starting a new union should be raised.
3. Establishing a convention that no union office bearer will concurrently hold office in a political party.
4. Trade unions should not be more fighting organisation of workers, but should be co-operating bodies to promote the cause of workers.
There are six persons Saurav, Harshita, Jay, Ashwini, Jagannath and Sakshi, who got different marks in the examination. Ashwini got more marks than all of them. Jay got more marks than two of them. Jagannath got less marks than only Ashwini. Saurav got less marks than 5 persons. Harshita got more marks than Jay while Sakshi got less marks than Jay. How many persons scored more marks than Sakshi?