Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Partija
- (
- PartijaID INT,
- TerenID INT,
- Datum DATE,
- VremePocetka TIME,
- VremeZavrsetka TIME,
- CONSTRAINT Partija_PK PRIMARY KEY(PartijaID)
- );
- INSERT INTO Partija VALUES (1, 1, '1/1/1978', '12:00', '13:00');
- INSERT INTO Partija VALUES (2, 2, '2/17/1990', '12:00', '13:00');
- INSERT INTO Partija VALUES (3, 3, '11/7/1991', '12:00', '13:00');
- INSERT INTO Partija VALUES (4, 4, '5/31/1980', '12:00', '13:00');
- INSERT INTO Partija VALUES (5, 5, '9/12/1993', '12:00', '13:00');
- INSERT INTO Partija VALUES (6, 6, '6/30/1991', '12:00', '13:00');
- INSERT INTO Partija VALUES (7, 7, '8/11/1984', '12:00', '13:00');
- INSERT INTO Partija VALUES (8, 8, '5/22/1983', '12:00', '13:00');
- INSERT INTO Partija VALUES (9, 9, '12/15/1981', '12:00', '13:00');
- INSERT INTO Partija VALUES (10, 10, '8/8/1975', '12:00', NULL);
- INSERT INTO Partija VALUES (11, 11, '8/8/1980', '12:00', NULL);
- INSERT INTO Partija VALUES (12, 12, '8/8/1960', '12:00', NULL);
- INSERT INTO Partija VALUES (13, 13, '8/8/1910', '12:00', NULL);
- INSERT INTO Partija VALUES (14, 14, '8/8/1990', '12:00', NULL);
- INSERT INTO Partija VALUES (15, 15, '8/8/2000', '12:00', NULL);
- SELECT PartijaID,VremePocetka,Datum FROM Partija WHERE VremeZavrsetka IS NULL ORDER BY Datum DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement