Hier sehen Sie (Weiterleitung drei Sekunden nach dem Speichern) das Ergebnis der Abfrage.
Abfragen können Sie per Klick auf den Namen ausführen. Der Klick auf die Id editiert die Abfrage. Abfragen nicht registrierter Nutzer können von
allen Nutzern editiert werden. Abfragen registrierter Nutzer nur von diesen.
Wenn Sie eine berechnete Spalte vermissen: Geben Sie der Spalte (As Spaltenname) einen Namen.
Transact-Sql kennt nicht die Klammern in Join-Ausdrücken, die Access fordert.
FROM (Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId) INNER JOIN Vertreter AS V ON U.VertreterId = V.VertreterId
funktioniert nicht. Stattdessen ohne Klammern:
FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId INNER JOIN Vertreter AS V ON U.VertreterId = V.VertreterId
Die Groß/Kleinschreibung ist zu beachten: Artikel <> ARTIKEL, A_Preis <> A_PREIS. Die Beispieltabellen nutzen die normale Groß-Kleinschreibung. Sql-Schlüsselwörter können beliebig notiert werden.
Weitere Hinweise finden Sie auf der Startseite Sql Online Tool
Select A1.VertreterId,
A1.V_Name,
A1.V_Ansch,
A1.V_Konto,
A1.V_Prov,
A3.ArtikelId,
A3.A_Name,
A3.A_Preis,
A2.UmsatzId,
A2.Datum,
A2.A_Stueck,
A3.A_Preis * A2.A_Stueck As Produkt
From Vertreter As A1 Inner Join Umsatz As A2
On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3
On A2.ArtikelId = A3.ArtikelId
Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select Reverse(SubString(Reverse(V_Name),PatIndex('%,%', Reverse(V_Name))+1, 30)) as Nachname, SubString(V_Name,PatIndex('%,%', V_Name)+1, 30) as Vorname From Vertreter
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt
From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId
Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select ArtikelId as ID, A_Name as Artikel, A_Preis as Preis, SUM (A_Stueck) as Anzahl_Verkaeufe, SUM (A_Stueck * A_Preis) as Einnahmen, SUM (A_Stueck * A_Preis * V_Prov) as Provision From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId Group by A_Name, A_Preis, ArtikelId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select
Reverse(SubString(Reverse(V_Name),PatIndex('%,%', Reverse(V_Name))+1, 30)) as Nachname,
SubString(V_Name,PatIndex('%,%', V_Name)+1, 30) as Vorname
From Vertreter
Select
Reverse(SubString(Reverse(V_Name),PatIndex('%,%', Reverse(V_Name))+1, 30)) as Nachname,
SubString(V_Name,PatIndex('%,%', V_Name)+1, 30) as Vorname
From Vertreter
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel Inner Join Umsatz on Artikel.ArtikelId = Umsatz.ArtikelId Inner Join Vertreter on Umsatz.VertreterId = Vertreter.VertreterId
Where A_Preis > 40
Group by A_Name, A_Preis
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel Inner Join Umsatz on Artikel.ArtikelId = Umsatz.ArtikelId Inner Join Vertreter on Umsatz.VertreterId = Vertreter.VertreterId
Group by A_Name, A_Preis
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name, A_Preis
Order by 'Anzahl_Verkaeufe'
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name, A_Preis, A_NR
Order by 'Anzahl_Verkaeufe'
Select
A_NR as ID,
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name, A_Preis, A_NR
Select
ArtikelId as ID,
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name, A_Preis, ArtikelId
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name, A_Preis
Select
A_Name as Artikel,
A_Preis as Preis,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by A_Name
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Artikel.A_Preis' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Select
V_Name as VertreterName,
SUM (A_Stueck) as Anzahl_Verkaeufe,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by V_Name
Select
V_Name,
SUM (A_Stueck) as Anzahl,
SUM (A_Stueck * A_Preis) as Einnahmen,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by V_Name
Select
V_Name,
SUM (A_Stueck) as Anzahl,
SUM (A_Stueck * A_Preis * V_Prov) as Provision
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by V_Name
Select
V_Name,
SUM (A_Stueck) as Anzahl,
SUM (A_Stueck * A_Preis * V_Prov) as Provision,
V_Konto as Kontostand
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Group by V_Name
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Select
V_Name,
SUM (A_Stueck) as Anzahl,
SUM (A_Stueck * A_Preis * V_Prov) as Provision,
V_Konto as Kontostand
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Select
V_Name as VertreterName,
SUM (A_Stueck) as AnzahlVerkaufteProdukte,
SUM (A_Stueck * A_Preis * V_Prov) as ErhalteneProvision,
V_Konto as KontostandVorher
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Select
V_Name as VertreterName,
SUM (A_Stueck) as AnzahlVerkaufteProdukte,
SUM (A_Stueck * A_Preis * V_Prov) as ErhalteneProvision,
V_Konto as KontostandVorher,
SUM (A_Stueck * A_Preis * V_Prov) + V_Konto as KontostandNachher
From
Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT
A_Name AS Produkt,
SUM(A_Stueck) AS Stueckzahl,
SUM(A_Preis*A_Stueck) AS Umsatz
FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId GROUP BY A_Name ORDER BY Umsatz
Select
V.V_Name as Name,
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov as Provisionsanteil,
V.V_Prov * U.A_Stueck * A.A_Preis as Provision
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V.V_Name like '[m]%'
order by V.V_Name
Select
V.V_Name as Name,
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov as Provisionsanteil,
V.V_Prov * U.A_Stueck * A.A_Preis as Provision
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V.V_Name like '%er%'
order by V.V_Name
Select
V.V_Name as Name,
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov as Provisionsanteil,
V.V_Prov * U.A_Stueck * A.A_Preis as Provision
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V_Name like '%er%'
order by V.V_Prov * U.A_Stueck * A.A_Preis
Select
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov as Provisionsanteil,
V.V_Prov * U.A_Stueck * A.A_Preis as Provision
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V_Name = 'Meyer, Emil'
order by V.V_Prov * U.A_Stueck * A.A_Preis
Select
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov * U.A_Stueck * A.A_Preis as Provision,
V.V_Konto + V.V_Prov * U.A_Stueck * A.A_Preis as Kontostand
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V_Name = 'Meyer, Emil'
Select
A.A_Name as Produktname,
A.A_Preis as Preis,
U.A_Stueck as Stückzahl,
U.A_Stueck * A.A_Preis as Gesamtpreis,
V.V_Prov * Gesamtpreis as Provision,
V.V_Konto + Provision as Kontostand
From
Artikel as A
Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId
Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Where V_Name = 'Meyer, Emil'
Select
A.A_Name,
A.A_Preis,
U.A_Stueck,
U.Datum,
V.V_Name,
V.V_Ansch,
V.V_Prov,
V.V_Konto
From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Order by U.UmsatzId
Select
A.A_Name,
A.A_Preis,
U.A_Stueck,
U.Datum,
V.V_Name,
V.V_Ansch,
V.V_Prov,
V.V_Konto
From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Order by U.A_Stueck desc, A.A_Preis desc
Select
A.A_Name,
A.A_Preis,
U.A_Stueck,
U.Datum,
V.V_Name,
V.V_Ansch,
V.V_Prov,
V.V_Konto
From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Order by U.A_Stueck desc, A.A_Preis
Select
A.A_Name,
A.A_Preis,
U.A_Stueck,
U.Datum,
V.V_Name,
V.V_Ansch,
V.V_Prov,
V.V_Konto
From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Order by U.A_Stueck desc
Select
A.A_Name,
A.A_Preis,
U.A_Stueck,
U.Datum,
V.V_Name,
V.V_Ansch,
V.V_Prov,
V.V_Konto
From Artikel as A Inner Join Umsatz as U on A.ArtikelId = U.ArtikelId Inner Join Vertreter as V on U.VertreterId = V.VertreterId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl,
A.A_Preis*U.A_Stueck as Gesamt,
A.A_Preis*U.A_Stueck*V.V_Prov as Provision,
A.A_Preis*U.A_Stueck*V.V_Prov + V.V_Konto as Kontostand
From Umsatz as U Right Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl,
A.A_Preis*U.A_Stueck as Gesamt,
A.A_Preis*U.A_Stueck*V.V_Prov as Provision,
A.A_Preis*U.A_Stueck*V.V_Prov + V.V_Konto as Kontostand
From Umsatz as U Left Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl,
A.A_Preis*U.A_Stueck as Gesamt,
A.A_Preis*U.A_Stueck*V.V_Prov as Provision,
A.A_Preis*U.A_Stueck*V.V_Prov + V.V_Konto as Kontostand
From Umsatz as U Inner Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl,
A.A_Preis * U.A_Stueck as Gesamt
From Umsatz as U Inner Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl,
Preis*Anzahl as Gesamt
From Umsatz as U Inner Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select
U.UmsatzId,
V.V_Name as Name,
A.A_Name as Produkt,
A.A_Preis as Preis,
U.A_Stueck as Anzahl
From Umsatz as U Inner Join Vertreter as V on U.VertreterId = V.VertreterId Inner Join Artikel as A on U.ArtikelId = A.ArtikelId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name,A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select VertreterId, V_Name, V_Ansch, V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select VertreterId, V_Name, V_Ansch, V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId ORDER BY Stueckzahl, Produkt
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name
ORDER BY Umsatz
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Produkt
ORDER BY Umsatz
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Stueck
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Preis
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Preis
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, SUM(A_Preis*A_Stueck) AS Umsatz FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Preis
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Stueck) AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Preis
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Preis) AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name,A_Preis
SELECT A_Name AS Produkt, SUM(A_Stueck*A_Preis) AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY A_Name
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Artikel.A_Preis' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT A_Name AS Produkt, SUM(A_Stueck*Preis) AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Stueckzahl
SELECT A_Name AS Produkt,SUM (A_Stueck) AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Stueckzahl
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
ORDER BY Stueckzahl, Produkt
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Produkt
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Produkt
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
GROUP BY Produkt
SELECT A_Name AS Produkt, A_Stueck AS Stueckzahl, A_Preis AS Preis FROM Artikel AS A INNER JOIN Umsatz AS U ON A.ArtikelId = U.ArtikelId
ORDER BY Stueckzahl
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
SELECT T3.ArtikelId AS Nummer, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck) AS Bruttoumsatz FROM Umsatz AS T3 INNER JOIN Artikel AS T1 ON T3.ArtikelId = T1.ArtikelId GROUP BY T3.ArtikelId, T1.A_Name ORDER BY Bruttoumsatz DESC
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A1.V_Name, A1.V_Ansch, A1.V_Konto, A1.V_Prov, A3.ArtikelId, A3.A_Name, A3.A_Preis, A2.UmsatzId, A2.Datum, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
Select A1.VertreterId, A2.A_Stueck, A3.A_Preis * A2.A_Stueck As Produkt From Vertreter As A1 Inner Join Umsatz As A2 On A1.VertreterId = A2.VertreterId Inner Join Artikel As A3 On A2.ArtikelId = A3.ArtikelId Order By A2.UmsatzId
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand_alt, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) + T2.V_Konto AS Kontostand_neu
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Kontostand_neu DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand_alt, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) + T2.V_Konto AS Kontostand_neu
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand_alt
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand_alt
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov, T2.V_Konto
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, T2.V_Konto AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov + T2.V_Konto) AS Kontostand
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov + T2.V_Konto) AS Provision
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) + T2.V_Konto AS Provision
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Konto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Provision ASC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz, SUM(T1.A_Preis * T3.A_Stueck * T2.V_Prov) AS Provision
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov AS Satz, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name, T2.V_Prov
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, T2.V_Prov, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Vertreter.V_Prov' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Nummer DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T2.V_Name AS Name, T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T3.VertreterId AS Nummer, T2.V_Name AS Name, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T3.VertreterId AS Nummer, T2.V_Name AS Name, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY Nummer, Name
ORDER BY Umsatz DESC
SELECT T3.VertreterId AS Nummer, T2.V_Name AS Name, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T3.VertreterId AS Nummer, T2.V_Name, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
INNER JOIN Vertreter AS T2
ON T3.VertreterId = T2.VertreterId
GROUP BY T3.VertreterId, T2.V_Name
ORDER BY Umsatz DESC
SELECT T3.VertreterId AS Nummer, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.VertreterId
ORDER BY Umsatz DESC
SELECT T3.ArtikelId AS Nummer, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck) AS Bruttoumsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Bruttoumsatz DESC
SELECT T3.ArtikelId AS Nummer, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck * 1.19) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId AS Nummer, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId AS Nummer, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck) AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId, T1.A_Name AS Artikel, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz DESC
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz ASC
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
ORDER BY Umsatz
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId, T1.A_Name
SELECT T3.ArtikelId, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz, T1.A_Name
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Artikel.A_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T1.A_Name
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Umsatz.ArtikelId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT T3.ArtikelId, SUM(T1.A_Preis * T3.A_Stueck)AS Umsatz
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY ArtikelId
SELECT T3.ArtikelId, T1.A_Name, SUM(T1.A_Preis * T3.A_Stueck)
FROM Umsatz AS T3
INNER JOIN Artikel AS T1
ON T3.ArtikelId = T1.ArtikelId
GROUP BY T3.ArtikelId
Fehler beim Erstellen der Abfrage
anonym
Column 'sql.dbo.Artikel.A_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT SUM(A_Stueck)
FROM Umsatz
WHERE A_Stueck > 10
ok
anonym
Mit dem Klick auf den Button stimmen Sie zu, daß Cookies in Ihrem Browser gespeichert werden.
Informationen zu den gespeicherten Cookies finden Sie unter Datenschutz#Cookies. Bei Fragen zur Technik wenden Sie sich bitte an Server-Daten - Web-Datenbank-Lösungen