11 Řešení roll up – hodnota ALL(1) Přetížení hodnot sloupce => přidání ALL SELECT Model, 'ALL', 'ALL', SUM(Prodeje) FROM Prodeje WHEREModel = Chevy GROUP BY Model UNION SELECT Model, Rok, 'ALL', SUM(Prodeje) FROM Prodeje WHERE Model = Chevy GROUP BY Model,Rok UNION SELECT Model, Rok, Barva, SUM(Prodeje) FROM Prodeje WHEREModel = Chevy GROUP BYModel, Rok, Barva;
{"Image DocumentName": "\u0158e\u0161en\u00ed roll up \u2013 hodnota ALL(1)", "Image ImageDescription": "P\u0159et\u00ed\u017een\u00ed hodnot sloupce => p\u0159id\u00e1n\u00ed ALL. SELECT Model, \u2018ALL\u2019, \u2018ALL\u2019, SUM(Prodeje) FROM Prodeje WHERE Model = Chevy GROUP BY Model UNION SELECT Model, Rok, \u2018ALL\u2019, SUM(Prodeje) FROM Prodeje WHERE Model = Chevy GROUP BY Model,Rok UNION SELECT Model, Rok, Barva, SUM(Prodeje) FROM Prodeje WHERE Model = Chevy GROUP BY Model, Rok, Barva;", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}