Did you know ...
Search Documentation:
CQL: Self JOIN
HOME
DOWNLOAD
SWI-Prolog
Sources/building
Docker images
Add-ons
Browse GIT
DOCUMENTATION
Manual
Packages
FAQ
Command line
PlDoc
Bluffers
▶
Prolog syntax
PceEmacs
HTML generation
License
Publications
Rev 7 Extensions
TUTORIALS
Beginner
▶
Getting started
Learn Prolog Now!
Simply Logical
Debugger
Development tools
Advanced
▶
Modules
Grammars (DCGs)
clp(fd)
Printing messages
PlDoc
Web applications
▶
Web applications
Let's Encrypt!
Pengines
Semantic web
▶
ClioPatria
RDF namespaces
Graphics
▶
XPCE
GUI options
Machine learning
▶
Probabilistic Logic Programming
External collections
▶
Meta level tutorials
For packagers
▶
Linux packages
COMMUNITY
IRC
Forum & mailing list
Blog
News
Report a bug
Submit a patch
Submit an add-on
Roadmap (on GitHub)
External links
Contributing
Code of Conduct
Contributors
SWI-Prolog items
COMMERCIAL
WIKI
Login
View changes
Sandbox
Wiki help
All tags
Documentation
Reference manual
Packages
Constraint Query Language A high level interface to SQL databases
library(cql/cql): CQL - Constraint Query Language
CQL Examples
CQL Simple INSERT
CQL Simple INSERT with retrieval of identity of the inserted
CQL Simple DELETE
CQL Simple SELECT
CQL Simple UPDATE
CQL WHERE with arithmetic comparison
CQL Simple INNER JOIN
CQL Arithmetic UPDATE with an INNER JOIN and a WHERE restriction
CQL: Confirm row does not exist
CQL: Aggregation - Count
CQL: Aggregation - Sum
CQL: Aggregation - Average
CQL: Maximum Value
CQL: Minimum Value
CQL: Aggregation requiring GROUP BY
CQL: INNER JOIN with an aggregation sub-query where the sub-query is constrained by a shared variable from the main query
CQL: INNER JOIN in an aggregation sub-query
CQL: Negation
CQL: EXISTS
CQL: Left Outer Join
CQL: List-based Restrictions
CQL: Compile time in-list constraint
CQL: Disjunction resulting in OR in WHERE clause
CQL: Disjunction resulting in different joins (implemented as a SQL UNION)
CQL: Disjunction resulting in different SELECT attributes (implemented as separate ODBC queries)
CQL: ORDER BY
CQL: DISTINCT
CQL: SELECT with NOT NULL restriction
CQL: First N
CQL: Self JOIN
CQL: Removing null comparisions
CQL: Three table JOIN
CQL: Three table JOIN with NOLOCK locking hint
CQL: SELECT with LIKE
CQL: Writing exceptions directly to the database
CQL: TOP N is Parametric
CQL: Using compile_time_goal/1
CQL: ON
CQL: Expressions In Where Restrictions
CQL: Explicitly avoid the "No WHERE restriction" message
CQL: HAVING
CQL: INSERT and UPDATE value in-line formatting
CQL: Negations in WHERE Clauses
CQL: Predicate-generated Attribute Values
CQL: INSERT from SELECT
1.7.30
CQL: Self JOIN
{[], se_lt_z :: [h-H, i-I1] =*= se_lt_z :: [h-H, i-I2], I1 \== I2}