Hello guys, I'm new to this forum as well as in oracle. I need a query which gives a count of production lets say product sales count from max date in single row. eg. Total Date 100 11-09-2014 this query should be fastest. please also help me to understand which one is fastest Whether rank, dense rank , joins and so on.