Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Teren
- (
- TerenID INT,
- Teren INT,
- Adresa nvarchar(50),
- GradID INT,
- KontaktTelefon nvarchar(20),
- CONSTRAINT Teren_pk PRIMARY KEY(TerenID)
- );
- INSERT INTO Teren VALUES(1,1,'adresa1',123,'0123456789');
- INSERT INTO Teren VALUES(2,2,'adresa1',223,'0123456789');
- INSERT INTO Teren VALUES(3,3,'adresa1',323,'0123456789');
- INSERT INTO Teren VALUES(4,4,'adresa1',423,'0123456789');
- INSERT INTO Teren VALUES(5,5,'adresa1',523,'0123456789');
- INSERT INTO Teren VALUES(6,6,'adresa1',523,NULL);
- INSERT INTO Teren VALUES(7,7,'adresa1',523,NULL);
- SELECT * FROM Teren WHERE KontaktTelefon IS NULL ORDER BY Teren DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement