Question
What is the primary purpose of the UNION ALL operator in
SQL?Solution
The UNION ALL operator in SQL is used to combine the results of two or more queries into a single result set. Unlike the UNION operator, which removes duplicate rows from the final result set, UNION ALL includes all rows, regardless of duplication. This makes UNION ALL useful when you want to retain all the data from the combined queries, including duplicates.
- Cost price of an item is Rs. (12n + 240). It is marked 50% above its cost price and sold after allowing a discount of Rs. (2n + 40). If the profit earned i...
- If the total cost of 9 mangoes and 6 oranges is Rs. 270 and the total cost of 7 mangoes and 4 oranges is Rs. 200, then find the cost of 5 mangoes.
The cost price of an article is ₹520. Some part of it is sold at 16% loss and the remaining part at some profit %. In this transaction, there is a pro...
Ritika purchased a washing machine for Rs. 18,000, listed it 30% above the cost price, and sold it after allowing successive discounts of 10% and 20%. W...
- An item was sold at Rs. 5000 making a 10% gain. If it had been sold at Rs. 4200, determine the approximate profit or loss percentage.
A shopkeeper sells an article at a loss of 25%. If he had sold it for Rs 240 more, he would have made a profit of 15%. Find the cost price of the article.
The cost price of an article is Rs. 2800 and a shopkeeper wants to earn 15% profit on it after giving 8% discount on marked price. Find the marked price...
The combined cost price of two products, P and Q, is Rs. 5000. Product P is marked up by 25% on its cost and Product Q is marked up by 40%. After giving...
A shopkeeper buys an article for 1200. He marks it 30% above cost price and gives 10% discount on marked price. What is his profit (in rupees)?
- The average cost price of articles 'M' and 'N' together is Rs. 500 where the cost price of article 'N' is Rs. 100 more than that of article 'M'. If article...
