EASY Query help...

[hrishy]

Hi

Is this what you are looking for

SELECT user_id,max_date_id
FROM  (
SELECT userid,MAX(data_id) max_date_id
		OVER(PARTITION by user_id)
FROM my_table
)
where max_date_id=0