You tried to execute a query that does not include the specified expression 'X' as

[saurabh678]

im having this same problem ..

this is my query ..

select title, url,sum(visit_count),microsoft from (select * from data_repository where (username='prasad'and microsoft>0 or title like '%microsoft%')) group by url ,title order by sum(visit_count) desc, microsoft desc;

can u tell me how i can fix this problem ??

thanks in advancee

[Rabbit]

Please use code tags when posting code. You have the field microsoft in your selection but you have not aggregated it or grouped by it. You need to do one or the other.

[saurabh678]

select title, url from (select * from data_repository where (username='daga'and java>0  or title like '%java%')) group by url ,title  order by Sum(visit_count) desc, java desc

is this fine ?

cause its still not working?

[Rabbit]

I don't even understand what you're trying to do there... You've made it way more complicated. Just take your original query and either group by the microsoft field or aggregate it. Which one you choose depends on what you want to do with the microsoft field.