04-09-2014 07:51 PM
I have a dataset named victimsummary of unique crash ID's with dr_lic_num1 being the driver's license number. Many dr_lic_num can show up in the dataset if they are involved in more than 1 crash. I need to filter the dataset to output the records for dr_lic_num1's that occur more than n times. At the beginning I am starting with n = 1 then working my way up after looking at the results.
I tried this code:
(select ID, dr_lic_num1, count(dr_lic_num1) as freq1
group by ID, dr_lic_num1
where freq1 > 1;
Any help is greatly appreciated!\
Need further help from the community? Please ask a new question.