Beispielausgaben zu Blatt 10 ============================ Bei den Abfragen 3 bis 6 wird hier nur ein Teilbereich (Beginn und Ende) der Ausgaben gezeigt. nh - 01/2009 1.) +---------------------------+ | ******* | +---------------------------+ | 12 | +---------------------------+ 1 row in set (0.00 sec) 2.) +-------------------+ | ****** | +-------------------+ | 701 | +-------------------+ 3.) +---------+-----------------------------------+-----------+----------+----------+--------------------------+ | orderID | productName | unitPrice | quantity | discount | ****** | +---------+-----------------------------------+-----------+----------+----------+--------------------------+ | 10248 | Queso Cabrales | 14 | 12 | 0 | 168 | | 10248 | Singaporean Hokkien Fried Mee | 10 | 10 | 0 | 100 | | 10248 | Mozzarella di Giovanni | 35 | 5 | 0 | 175 | | 10249 | Tofu | 19 | 9 | 0 | 171 | | 10249 | Manjimup Dried Apples | 42 | 40 | 0 | 1680 | | 10250 | Jack's New England Clam Chowder | 8 | 10 | 0 | 80 | | 10250 | Manjimup Dried Apples | 42 | 35 | 0.15 | 1470 | | 10250 | Louisiana Fiery Hot Pepper Sauce | 17 | 15 | 0.15 | 255 | | 10251 | Gustaf's Knäckebröd | 17 | 6 | 0.05 | 102 | | 10251 | Ravioli Angelo | 16 | 15 | 0.05 | 240 | | 10251 | Louisiana Fiery Hot Pepper Sauce | 17 | 20 | 0 | 340 | | 10252 | Sir Rodney's Marmalade | 65 | 40 | 0.05 | 2600 | | 10252 | Geitost | 2 | 25 | 0.05 | 50 | . . . (hier kommen noch jede Menge weiterer Zeilen . . | 11077 | Röd Kaviar | 15 | 2 | 0.01 | 30 | | 11077 | Rhönbräu Klosterbier | 8 | 4 | 0 | 32 | | 11077 | Original Frankfurter grüne Soße | 13 | 2 | 0 | 26 | +---------+-----------------------------------+-----------+----------+----------+--------------------------+ 2155 rows in set (0.08 sec) 4.) +-----------------------------------+------------+---------------------------+ | companyName | orderDate | productName | +-----------------------------------+------------+---------------------------+ | Antonio Moreno Taquería | 1997-04-15 | Ipoh Coffee | | Antonio Moreno Taquería | 1997-06-19 | Sasquatch Ale | | Around the Horn | 1997-02-21 | Outback Lager | | B's Beverages | 1997-05-15 | Outback Lager | | B's Beverages | 1997-06-24 | Steeleye Stout | . . . | Wartian Herkku | 1997-05-30 | Steeleye Stout | | Wellington Importadora | 1997-01-21 | Outback Lager | | White Clover Markets | 1997-03-10 | Chang | | White Clover Markets | 1997-03-24 | Sasquatch Ale | | White Clover Markets | 1997-04-11 | Chang | +-----------------------------------+------------+---------------------------+ 82 rows in set (0.30 sec) 5.) +----------------+-----------------------------------+-----------------------------+ | catName | productName | ******* | +----------------+-----------------------------------+-----------------------------+ | Beverages | Côte de Blaye | 150215 | | Beverages | Chai | 14208 | | Beverages | Chang | 18479 | | Beverages | Chartreuse verte | 13026 | | Beverages | Guaraná Fantástica | 4500 | | Beverages | Ipoh Coffee | 25114 | | Beverages | Lakkalikööri | 16698 | | Beverages | Laughing Lumberjack Lager | 2561 | | Beverages | Outback Lager | 11472 | . . . | Seafood | Nord-Ost Matjeshering | 14882 | | Seafood | Röd Kaviar | 4200 | | Seafood | Røgede sild | 4990 | | Seafood | Spegesild | 6216 | +----------------+-----------------------------------+-----------------------------+ 77 rows in set (0.06 sec) 6.) +------------------------------------+-------------------------------+ | companyName | ********* | +------------------------------------+-------------------------------+ | Ana Trujillo Emparedados y helados | 63 | | Around the Horn | 4434 | | Berglunds snabbköp | 2220 | | Blauer See Delikatessen | 290 | | Bon app' | 1490 | . . . | White Clover Markets | 2691 | | Wilman Kala | 508 | | Wolski Zajazd | 588 | +------------------------------------+-------------------------------+ 48 rows in set (0.29 sec)