CREATE INDEX idx_lastname ON customers (last_name(20));
SEELCT COUNT (DISTINCT LEFT (last_name, 1))
FROM customers;
Before running this I already get an error "DISTINCT is not valid at this position… "
How to fix it? Thank you.
CREATE INDEX idx_lastname ON customers (last_name(20));
SEELCT COUNT (DISTINCT LEFT (last_name, 1))
FROM customers;
Before running this I already get an error "DISTINCT is not valid at this position… "
How to fix it? Thank you.
Neve mind guys…figured it out. Took away space between COUNT and (