I have a query that looks like this:
select min(priority),keyword
from table
where condition
group by keyword
which it works fine, except that I want the query to return other feilds in the select, but I keep getting errors because of the aggrigate function min. any help
thanx
select min(priority),keyword
from table
where condition
group by keyword
which it works fine, except that I want the query to return other feilds in the select, but I keep getting errors because of the aggrigate function min. any help
thanx