limit rows

Jazzy88 · #1 (**permalink**) 09-08-11, 16:54

Hi,

I have a table like:

Name date numb

jan 7/11/11 3
truus 3/10/11 6
pieter 7/09/11 8
sjon 1/02/11 2
truus 4/10/11 0
pieter 7/12/11 1
jan 1/01/11 6
sjon 7/11/11 7

and so on.

I need to limit the rows, from each name the highest 5 dates and then the sum of numb.

please help me

thank you

shammat · #2 (**permalink**) 09-08-11, 17:26

Not sure about the "then the sum of numb" part, but if you are looking for a single value per name, then this is probably what you are looking for:

Code:

SELECT name
       sum(numb)
FROM (
    SELECT name,
           date,
           numb,
           row_number() over (partition by name order by date desc) as row_num
    FROM your_table
) t
WHERE row_num <= 5 
GROUP BY name

Internet Services

Web Development

Digital Marketing

Consumer Tech