Учебники по
SQL (Structured Query Language — «язык структурированных запросов»).
Пример кода:DROP TABLE DROP TABLE ACCESS;
CREATE TABLE ACCESS ( id INTEGER, person_id INTEGER, object_id INTEGER, serial TEXT, date_from DATE, date_to DATE, about INTEGER );
SELECT first.cname, second.cname, first.rating FROM Customers first, Customers second WHERE first.rating = second.rating AND first.cname < second.cname;
|