[ library(mysql) | ]
sql_querydistinct(++Attributelist, ++Tables, +Where, +MoreOptions, ?Valuelist)
Query the database without duplicates
- Attributelist
- List of atoms or strings
- Tables
- Atom or string
- Where
- Atom or string
- MoreOptions
- Atom or string
- Valuelist
- Variable or partially instantiated list
Description
This is exactly like sql_query/5, except that duplicates are eliminated.
In practice this means that the SQL keyword DISTINCT is inserted into
the corresponding SQL statement.
Resatisfiable
yes
See Also
sql_insert / 3, sql_query / 5, sql_select / 2