http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?action=history&feed=atom&title=Slide%2FExamples_GroupBy_OrderBy_Having 2026-08-08T20:43:22Z Revision history for this page on the wiki MediaWiki 1.39.1 http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?title=Slide/Examples_GroupBy_OrderBy_Having&diff=545&oldid=prev 2023-04-05T07:12:12Z

<p>modified through wikirestore by Sysop</p> <p><b>New page</b></p><div>== Links ==<br /> <br /> <br /> * {{Link|target=keyword/SELECT|title=SELECT}}<br /> * {{Link|target=keyword/FROM|title=FROM}}<br /> * {{Link|target=keyword/MIN|title=MIN}}<br /> * {{Link|target=keyword/MAX|title=MAX}}<br /> * {{Link|target=keyword/AVG|title=AVG}}<br /> * {{Link|target=keyword/GROUP BY|title=GROUP BY}}<br /> * {{Link|target=keyword/HAVING|title=HAVING}}<br /> * {{Link|target=keyword/COUNT|title=COUNT}}<br /> * {{Link|target=keyword/ORDER BY|title=ORDER BY}}<br /> <br /> <br /> <br /> == Links hierher ==<br /> {{WhatLinksHere}}<br /> &lt;pdf page=&#039;36&#039;&gt;4-RelationaleDatenbankspracheSQL.pdf&lt;/pdf&gt;<br /> = Meta =<br /> {{Slide<br /> |qkey=SQL-36<br /> |pkey=SQL<br /> |basename=4-RelationaleDatenbankspracheSQL.pptx<br /> |page=36<br /> |pdf_page=36<br /> |name=Examples_GroupBy_OrderBy_Having<br /> |title=Beispiele_ GROUP BY, ORDER BY, und HAVING<br /> |keywords=SELECT, FROM, MIN, MAX, AVG, GROUP BY, HAVING, COUNT, ORDER BY<br /> |links=<br /> |literature=<br /> <br /> |storemode=property<br /> }}<br /> = Text =<br /> &lt;pre&gt;<br /> Beispiele: GROUP BY, ORDER BY, und HAVING<br /> Beispiele:•Erstelle eine alphabetisch sortierte Liste aller Waren, in der für jede Ware der minimale, maximale und der Durchschnittspreis angegeben ist:• •SELECT Ware, MIN (Preis), MAX (Preis), AVG (Preis)• FROM Lieferant• GROUP BY Ware• ORDER BY Ware ASC•Welche Waren werden nur von •einem Lieferanten geliefert?• SELECT Ware FROM Lieferant• GROUP BY Ware• HAVING COUNT(*) = 1<br /> <br /> <br /> &lt;/pre&gt;<br /> &lt;headertabs/&gt;</div>

Sysop