Complex Ranking

[Bryan Guirnela]

Hi guys,

I am Trying to create a ranking query which will rank the the dates on the table if the name and offense matches.

Name * Offense * Date * What I want
Bryan * Absence * 1/12/2011 * 1
Bryan * Absence * 1/13/2011 * 2
Bryan * Tardy * 1/14/2011 * 1
Bryan * Tardy * 1/15/2011 * 2
Vishal * Absence * 1/16/2011 * 1
Vishal * Absence * 1/17/2011 * 2
Vishal * Absence * 1/18/2011 * 3
Vishal * Absence * 1/19/2011 * 4
Vince * Tardy * 1/20/2011 * 1
Vince * Tardy * 1/21/2011 * 2
Vince * Tardy * 1/22/2011 * 3

so if you look at column 4 it shows ranking per name per offense.

Any help regarding this matter will be greatly appreciated.

[Rabbit]

You do it like a regular ranking query except you add your two new conditions into the subquery's WHERE clause.

[Bryan Guirnela]

can you be more specific on the syntax? ive been tryin to fiddle around with it but i cant seem to make it right.. :(

[Rabbit]

What do you have so far?

[Bryan Guirnela]

I was able to create one, although it took me a qouple of qeries then i had to connect them all.but it works hehe..Thanks anyway.