Spatialite geometric SQL samples

SpatialSQLExamples.txt

there is a quick reference guide for 3D geoms: 
http://www.google.com/url?sa=D&q=http://www.gaia-gis.it/spatialite-2.4.0/SpatiaLite-Geometries-Addendum.pdf

Anyway, you can follow this SQL sample: 

CREATE TABLE t2d 
 (Id INTEGER PRIMARY KEY NOT NULL); 

SELECT AddGeometryColumn('t2d', 'Geom', 
 4326, 'POINT', 'XY'); 

INSERT INTO t2d (Id, Geom) VALUES 
 (1, ST_GeomFromText('POINT(1 2)', 4326)); 

INSERT INTO t2d (Id, Geom) VALUES 
 (2, ST_GeomFromText('POINT(3 4)', 4326)); 

CREATE TABLE t3d 
 (Id INTEGER PRIMARY KEY NOT NULL); 
SELECT AddGeometryColumn('t3d', 'Geom', 
 4326, 'POINT', 'XYZ'); 

INSERT INTO t3d (Id, Geom) VALUES 
 (1, ST_GeomFromText('POINT Z(1 2 10)', 4326)); 

INSERT INTO t3d (Id, Geom) VALUES 
 (2, ST_GeomFromText('POINTZ(3 4 20)', 4326)); 

CREATE TABLE t4d 
 (Id INTEGER PRIMARY KEY NOT NULL); 
SELECT AddGeometryColumn('t4d', 'Geom', 
 4326, 'POINT', 'XYZM');

INSERT INTO t4d (Id, Geom) VALUES 
 (1, ST_GeomFromText('POINT ZM(1 2 10 100)', 4326)); 

INSERT INTO t4d (Id, Geom) VALUES 
 (2, ST_GeomFromText('POINTZM(3 4 20 200)', 4326)); 

SELECT Id, ST_AsText(Geom), ST_GeometryType(Geom) 
 FROM t2d; 

SELECT Id, ST_AsText(Geom), ST_GeometryType(Geom) 
 FROM t3d; 

SELECT Id, ST_AsText(Geom), ST_GeometryType(Geom) 
 FROM t4d;