< nknabe.dk

The table NamesList as SQL

N.B. Some DBMSs may require quoted tables and fields names.

CREATE TABLE NamesList (
Idx INTEGER
, FirstName VARCHAR(20)
, LastName VARCHAR(20)
);
INSERT INTO NamesList VALUES (1, 'Otto', 'Lilienthal');
INSERT INTO NamesList VALUES (2, 'Augustus', 'Herring');
INSERT INTO NamesList VALUES (3, 'Wilbur', 'Wright');
INSERT INTO NamesList VALUES (3, 'Orville', 'Wright');
INSERT INTO NamesList VALUES (4, 'Alberto', 'Santos-Dumont');
INSERT INTO NamesList VALUES (5, 'Louis', 'Blériot');
INSERT INTO NamesList VALUES (6, 'Charles', 'Lindbergh');

SELECT * FROM NamesList;