Recent content by bergjes

Hi Pilsdumps. Thanks for your quick response. I tried your solution, but I think I'm doing somthing wrong, because it doesn't work. Here is my code: SELECT punten_dag.* DENSE_RANK() OVER(ORDER BY punten_dag.dag) as _rank FROM punten_dag; But this code gives a syntax error. Do I have to...

I know there are many threads about ranking, but I cannot figure out how things work. I hope somebody can explain how to rank my query (see attachment). I want to use dense_rank, it has to be ranked each day and order by ranking. Hope somebody knows what I mean. Thanks, Erik