SQL, Select Distinct and Left in one

Question

I want to SELECT a number of rows in a SQL database using both

DISTINCT

and

LEFT

.

Below is the effort so far.

SELECT DISTINCT(alltext) LEFT(alltext, 100)

FROM programoversigter3

WHERE alltext LIKE '%kommunisme%'

Answer 1

DISTINCT is a keyword not a function and you need to use , after each column. So, your query should be

SELECT DISTINCT alltext, LEFT(alltext, 100)
FROM programoversigter3
WHERE alltext LIKE '%kommunisme%'

Sign up