The grouping for the view is done on those three columns so that is where you want the index on as that is what any query on the view would...

So that you don't have to query the table multiple times you can use the RANK function:

SELECT salary,d.department_name FROM

(

SELECT e.salary,d.department_name,RANK() OVER(ORDER BY e.salary) myrank

FROM employees e JOIN departments d...

I can't see how connecting to the wrong server/database or any server setting or table change can be related to the error the query returns.

The query itself just has...

Could it be that a column was deleted or modified. As the error suggests unless there was a e.region in the select statement or in the group by, I would...

Hi Natasha,

I dont fully understand the problem. I can't see anything wrong with your query.

The query will return date outs after 03/Jan/2004 for books published before 1920 which from what...