Advertisement
Pavle_nis

Untitled

Feb 21st, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | None | 0 0
  1. CREATE TABLE Teren
  2. (
  3.     TerenID INT,
  4.     Teren INT,
  5.     Adresa nvarchar(50),
  6.     GradID INT,
  7.     KontaktTelefon nvarchar(20),
  8.     CONSTRAINT Teren_pk PRIMARY KEY(TerenID)
  9. );
  10.  
  11. INSERT INTO Teren VALUES(1,1,'adresa1',123,'0123456789');
  12. INSERT INTO Teren VALUES(2,2,'adresa1',223,'0123456789');
  13. INSERT INTO Teren VALUES(3,3,'adresa1',323,'0123456789');
  14. INSERT INTO Teren VALUES(4,4,'adresa1',423,'0123456789');
  15. INSERT INTO Teren VALUES(5,5,'adresa1',523,'0123456789');
  16. INSERT INTO Teren VALUES(6,6,'adresa1',523,NULL);
  17. INSERT INTO Teren VALUES(7,7,'adresa1',523,NULL);
  18.  
  19. SELECT * FROM Teren WHERE KontaktTelefon IS NULL ORDER BY Teren DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement