Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE
- FROM rechnung
- WHERE rechnr = 4743;
- SELECT *
- FROM kunde
- WHERE knr NOT IN (SELECT re.knr FROM rechnung re);
- SELECT
- re.rechnr AS [Nummer],
- re.betragRechnung [Betrag],
- (
- SELECT SUM(z.betrag)
- FROM zahlung z
- WHERE z.rechnr = re.rechnr
- ) AS [Bezahlter Betrag]
- FROM rechnung re
- WHERE re.knr = 1073;
- SELECT re.rechnr, ku.vorname, ku.name
- FROM rechnung re INNER JOIN kunde ku ON ku.knr = re.knr
- WHERE (
- SELECT COUNT(res.resnr)
- FROM reservierung res
- WHERE res.rechnr = re.rechnr
- ) > 1;
- SELECT
- ku.knr,
- ku.name,
- ku.vorname,
- re.rechnr,
- (
- SELECT SUM(re.betragRechnung)
- FROM rechnung re
- WHERE re.knr = ku.knr
- ) AS [Zu bezahlen],
- (
- SELECT SUM(z.betrag)
- FROM zahlung z
- WHERE z.rechnr = re.rechnr
- ) AS [bezahlt]
- FROM (kunde ku INNER JOIN rechnung re ON ku.knr = re.knr)
- WHERE
- YEAR(re.datum) = 2019 AND
- MONTH(re.datum) = 1 AND
- [bezahlt] < [Zu bezahlen];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement