group by a fields first n character
-
hi, i have table and i want to make a select * query that group by first 4 character of second field
is there anybody knows that?
-
is something like:
select fld1, fld2, sum(*)
from table
group by fld1, Left(fld2,4)
??
* Noel -
Group by or order by???
Can we see the table definition and some sample data with the expected results from the query?
-
thanks a lot noeld, you swithed on a lamp in my mind.
-
Can you tell us what you're trying to do?
-
I am glad I did because all I did was just a guess
* Noel -
It's the most accurate guess you could make
.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply