CODEWITHSUNDEEP
sqlfirebird
nordin
nordin

Reputation: 167

Sql select distinct in a firebird database

SO I have this firebird database and I am trying to select the users with this query:

SELECT DISTINCT Fi_GEBRUIKER1 FROM BANDZENDINGEN

I use razorsql. but DISTINCT is colored red, I assume this means I am doing something wrong.

enter image description here

What am I doing wrong? Please help.

EDIT

oke it just worked, but it took about 200 seconds and if I try it on my website my webiste crashes with this error message: ERROR 503 - Service Unavailable!

Upvotes: 1

Views: 7127

Answers (1)

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 31991

DISTINCT is a statement used to return only distinct (different) values as it is reserve word so your editor show it in different color it does not mean wrong

SELECT DISTINCT Fi_GEBRUIKER1 FROM BANDZENDINGEN

your query is fine it will work

Upvotes: 2

Related Questions